Using @@rowcount

Posted Date: 04 Jul 2008	Resource Type: Code Snippets	Category: ADO.NET
Author: apeksha	Member Level: Bronze
Rating:	Points: 5

Here is a code sample that uses @@rowcount to give the number of rows given as an result of a query.



Create procedure get_emp_count (@emp_id int) 
As Select * from emp where emp_id = @emp_id 
If @@rowcount = 0 
Begin 
Select 'no rows with emp_id = ' 
Select @emp_id 
End

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Sql . Rowcount .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: ExecuteReader Implementation
	Previous Resource: Bulk Copy - Using Transcation - Moving Data From One Server to Another Server (Central)
	Return to Discussion Resource Index
	Post New Resource
	Category: ADO.NET

Post resources and earn money!

Related Resources