1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How do you find the error, how can you know the number of
rows effected by last SQL statement?

Question Posted / kaumil2001


How do you find the error, how can you know the number of rows effected by last SQL statement?..

Answer / laxman

select @@error
select @@rowcount

Is This Answer Correct ?    10 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Is oracle faster than sql server?

0 Answers  

How to bind a view to the schema of the underlying tables?

0 Answers  

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

How to create prepared statements using odbc_prepare()?

0 Answers  

How to attach adventureworkslt physical files to the server?

0 Answers  




Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

What is logshipping and its purpose?

0 Answers  

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

Explain what are commit and rollback in sql?

0 Answers  

What is isnull() operator?

0 Answers  

What are different types of replication in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories