How do you find the error, how can you know the number of
rows effected by last SQL statement?
Answer Posted / chandra rekha
select @@error'Error'
select @@rowcount'Rows'
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can we update data in a view?
Tell me what are cursors and when they are useful?
Explain system rowset functions?
How can you control the amount of free space in your index pages?
How many null values we can have in a unique key field in sql server?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is a constant or literal in ms sql server?
Explain the creation and execution of a user-defined function in the sql server?
Explain the properties of sub-query in sql server?
how you can deploy an ssrs report?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is sql server profiler trace data file?
How to add a new dsn with the odbc driver for sql server?
please differentiate between delete and truncate?
What is difference between oltp and olap?