How can I get count of one select during selecting in SQL Server

Question

I have a big select with many inner join and left join and select to select like:

SELECT 
    ( ... ) 
ORDER BY 
    Price

The question is for count of select am I must to run this select again ?

SELECT    
    COUNT( ... )  
ORDER BY 
    Price

Is there any easy way to run one times and get result of select and count of select ?

Here is my C# code with Entity Framework:

string strQuery = "....";

IQueryable<ProductDto> list = _entities.Database.SqlQuery<ProductDto>(strQuery).AsQueryable();

Community · Accepted Answer · 2017-05-23 10:27:47Z

3

You can use select @@rowcount to get the number of rows selected by the previous statement as a second resultset, or use SET @myOutputVar = @@ROWCOUNT it as an output parameter of your stored procedure.

A few Q/A's here on StackOverflow that may also help

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Jul 25, 2016 at 8:40

Jamiec

136k15 gold badges143 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

dan Over a year ago

Can you show it on my query please , I didn't understand it

Jamiec Over a year ago

@dan - how do you execute your select is it a stored procedure? Is it called from .NET code?

Jamiec Over a year ago

@dan - have you seen this: CountAsync()

Manish Kumar · Accepted Answer · 2016-07-25 08:47:39Z

0

Yes you can try select @@rowcount.It Returns the number of rows affected by the last statement. If the number of rows is more than 2 billion, use ROWCOUNT_BIG.

https://msdn.microsoft.com/en-IN/library/ms187316.aspx

answered Jul 25, 2016 at 8:47

Manish Kumar

5175 silver badges15 bronze badges

Collectives™ on Stack Overflow

How can I get count of one select during selecting in SQL Server

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related