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.
| 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 TABLEA3 WHERE a>b and4 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>db) 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. |
 |
|
|
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. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-11-22 : 05:04:44
|
| see the example i wrote:1 SELECT *2 FROM TABLEA3 WHERE a>b and4c>di want to see the number of rows in the code in management studio |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-11-22 : 06:08:04
|
This is one way:SELECTCOUNT(*) OVER (PARTITION by (SELECT 1)) as numrows,*FROM TABLEWHERE ...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
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 |
|
|
|
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) |
|
|
|
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. |
|
|
|
|
|
|
numbers of rows