ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How do you find the error, how can you know the number of
rows effected by last SQL statement?
 Question Submitted By :: Kaumil2001
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do you find the error, how can you know the number of rows effected by last SQL statement?
Answer
# 1
select @@error
select @@rowcount
 
Is This Answer Correct ?    1 Yes 0 No
Laxman
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to write stored procedure to update the data in 10 tables  3
What is normalization?  5
How to count the number of duplicate items in a table?  1
Explain Active/Active and Active/Passive cluster configurations  1
What is a Join in SQL Server?  1
what is curser.  7
could u plz explain about joins and views?  2
What is a Stored Procedure?  5
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?  2
can we call functions from stored procedure in SQL Server 2005 ? How?  2
What are Sql Reporting Services and analysis services? Can u Explain  1
Wht is SQL Injection Attack ?  1
any one can explain Self mapping Delegation Remote Credentials  1
difference between sql server2000 and sql server2005  1
Is trigger fired implicitely?  2
What is the difference between distinct clause and group by clause? Value-Labs1
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?  1
explain different types of jions with examples briefly? Zensar2
How will u get 5 years back record?  3
How to Get the last identity value used  3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com