What is @@rowcount and with small code snippet explain the
usage?
Answer Posted / guest
@@rowcount gives the number of rows given as an result of
previous query ran.
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
Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the different execute methods of Ado.Net?
How do you implement locking concept for dataset?
What is ado.net explain with diagram?
What are all the different methods under sqlcommand?
What are ado.net objects?
How is entity framework different from ado.net?
Explain how to pass multiple tables in datasets simultaneously?
What do you mean by ‘batch updates’?
What is dbcontext and dbset in entity framework?
Which method in OLEDBAdapter is used to populate dataset with records?
Explain ODP.net
Which database is the ado.net?
What is ado recordset?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What are the important features of ado.net 2.0?