Answer Posted / Huma Rizvi
@@ROWCOUNT is a system function in SQL Server that returns the number of rows affected by the last statement executed. It can be used to check if any rows were inserted, updated, or deleted.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between upgrade and migration in sql server?
How do I create a trace in sql server?
What are different types of constraints?
How to connect php with different port numbers?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is normalization and what are the advantages of it?
Can we shrink data file in sql server?
How to enter binary string literals in ms sql server?
What is temporary table in sql server? Why we use temp table?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the difference between for xml raw and for xml auto?
Can you index views?
what is spatial nonclustered index
Why should you use or avoid select * statements?
Is it possible to have clustered index on separate drive from original table location?
