>>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

Yes, I understand. But I did not think that SQL Server will set @@ERROR if no record in the table has CommunID = @nParm1.