@@error - displays the error number of last T-Sql statement @@rowcount

How can you get @@error and @@rowcount at the same time?

Question Posted / raji

Answer Posted / raji

@@error - displays the error number of last T-Sql statement
@@rowcount - displays the total row count of last T-Sql
statement

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to handle error or exception in sql?

1040

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

How to replace the Query Result 'Null Value' with a text ?

1098

What is a transact-sql statement?

1131

Can a cursor be updated? If yes, how you can protect which columns are updated?

1176

What is scrollable cursor?

1080

Explain the different types of joins?

1046

Distinguish between nested subquery and correlated subquery?

1115

Find columns used in stored procedure?

1039

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2858

How to replace null values in expressions using isnull()?

1152

What are the types of dml?

1032

What is the difference between truncate and delete commands?

1110

How adventureworkslt tables are related?

984

How can you know if the row fetched from cursor is still valid in underlying table?

1048