Interested to Buy Any Domain ? << Click Here >> for more details...
How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 23934 Views
- I also Faced
- E-Mail Answers
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
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
List the different types of collation sensitivities in sql server?
What does it mean to manipulate data?
Explain how to send email from sql database?
Are resultset updatable?
What is join and name different type of joins?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to delete exactly duplicate records from a table?
What number sorts of privileges are accessible in sql?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is the library index called?
What are the benefits of filtered indexes?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is purpose of normalization?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
