Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

Name 3 ways to get an accurate count of the number of records in a table?

May 13 2012 12:00AM by Nirav Gandhi   

Question

Name 3 ways to get an accurate count of the number of records in a table?

Answer

  1. SELECT COUNT(*) FROM table1
  2. SELECT * FROM table1
  3. SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2

Read More..   [32134 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  · 

Nirav Gandhi
38 · 5% · 1503
0
Liked
 
0
Asked


Submit

Your Comment
Sign Up or Login to post a comment.
"Name 3 ways to get an accurate count of the number of records in a table?" rated 5 out of 5 by 2 readers
Name 3 ways to get an accurate count of the number of records in a table? , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]