How can you get @@error and @@rowcount at the same time?
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 |
Post New Answer View All Answers
What is xdr?
Tell me what is fill factor?
What is raid and what are different types of raid levels?
Does a sql server 2005 select statement require a from?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the order by used for?
What is the filtered index?
What are relationships and mention different types of relationships in the dbms
What is the distinction amongst delete and truncate?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
How would you go about developing a ssrs report?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Is the primary key column of a table an index in ms sql server?
How many databases instances are there in sql server 2000?
What is table value parameters (tvp)?