>Will SQL Server set @@ERROR if @nCommunID does not exist in the table?

@nCommunID is an input parameter. It could have very easily been called @nParm1 and used like this:

DELETE FROM community WHERE communid = @nParm1