To get the row count in a faster way , the conventional way would be very slow.
SELECT rows FROM sysindexes
WHERE id = OBJECT_ID('TABLEA') AND indid < 2
TABLEA : Is the name of the table
You see things; and you say 'Why?' But I dream things that never were; and I say 'Why not?'
Monday, February 9, 2009
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
-
▼
2009
(33)
-
▼
February
(8)
- Stored procedure which were created in last 7days
- To get the row count in a faster way
- Unmatching records between two tables
- Exporting the output into a text or csv file
- Taking a backup or creating a duplicate table
- Doing a bulk insert of a text file in temp table
- Getting a SQL Server RowCount Without doing a Tabl...
- How to get length of data in Text, NText and Image...
-
▼
February
(8)
No comments:
Post a Comment