Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

@@rowcount can be used to verify the success of selected operations

After each Transact-SQL statement, the server sets the value of  this variable to the total  number of records affected by it.  9>      select 1+2 10>      GO -----------           3 (1 rows affected) 1> 2>      if @@rowcount = 0 3>         Print "No rows were copied!" 4> GO 1>