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

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4370

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1036

What do you need to connect php to sql server?

1099

What is bit data type?

1020

What is format parameter in ssrs?

144

What are the different types of triggers in SQL SERVER?

1118

Can we join two tables without primary key?

1036

Explain what is use of dbcc commands?

1045

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1054

What are indexes in sql?

1269

What does executeupdate return?

967

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

936

What is a fill factor?

1076

What is difference between equi join and inner join?

930

Can we add a cpu to sql server?

998