Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 numbers of rows

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-11-22 : 00:57:11
how can i see the numbers of rows in my query (ssms)


like:

1 SELECT *
2 FROM TABLEA
3 WHERE a>b and
4 c>d

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2010-11-22 : 04:50:08
a) SELECT count(*) FROM TABLEA WHERE a>b and c>d
b) use the recordset.recordcount property. in VB this is only available for certain recordset types (and there is a performance downside to using those types)....otherwise you have to count the records yourself in the returned recordset.

Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-11-22 : 04:50:22
In the right lower corner of your query window you can see the number of rows returned by your query.
If that isn't what you want to know then be more specific please.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-11-22 : 05:04:44
see the example i wrote:

1 SELECT *
2 FROM TABLEA
3 WHERE a>b and
4c>d

i want to see the number of rows in the code in management studio
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-11-22 : 06:08:04
This is one way:
SELECT
COUNT(*) OVER (PARTITION by (SELECT 1)) as numrows,
*
FROM TABLE
WHERE ...


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

inbs
Aged Yak Warrior

860 Posts

Posted - 2010-11-22 : 07:08:07
i thinks that is something in "properties"

i see it in some examples but i do not find where it is
Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2010-11-24 : 12:34:20
Are you trying to get the line numbers to appear?

Tools -> Options -> Text Editor -> All Languages -> General -> Line Numbers checkbox

=======================================
No matter what side of the argument you are on, you always find people on your side that you wish were on the other. -Jascha Heifetz, violinist (1901-1987)
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-11-24 : 16:30:11
OMG!
line numbers


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -