Latest DotNet & SQLQuestions
Wednesday, 30 March 2011
Different 3 ways to get an accurate count of the number of records in a table?
SELECT
*
FROM
table1
SELECT
COUNT
(*)
FROM
table1
SELECT
rows
FROM
sysindexes
WHERE
id
=
OBJECT_ID
(
table1
) AND
indid
<
2
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment