C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !



Posted By: Ramachandra Prabhu       Member Level: Silver       Posted Date: 10 Apr 2008       Category: SQL Server

@@RowCount

What is the value of the send @@RowCount in the following SQL statement?
SELECT * FROM Tablename

SELECT @@ROWCOUNT

SELECT @@ROWCOUNT
Select Answer:

Number of records in Table
0
1
2




      
Your Test Score: 0 / 0



Next Question: Which data type would you use to store up to 2 GB of text data and still be able to query and manipulate it by using standard functions and operators?
Previous Question: Which is not a return value of @@FETCH_STATUS variable
Related Questions:
  • Triggers


  • What is the output of the following SQL statement? select TRANSLATE('MASTER AUTHOR', 'MAOU', 'Maou')


  • how many foreign key maximum we can use in one table


  • SQL Server Table Hint - 'NOLOCK'


  • what transaction that see or that do not see rows that are inserted or deleted from another transaction that is not committed yet.


    		•

    Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers   BizTalk Adaptors    Web Design

    teleconferencing

    Contact Us    Privacy Policy    Terms Of Use