Interested to Buy Any Domain ? << Click Here >> for more details...
What is @@rowcount and with small code snippet explain the
usage?
- 4 Answers
- 14820 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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
How can I retrieve two tables of data at a time by using data reader?
What is difference between connected and disconnected architecture in ado.net?
What is ado code?
Describe the disconnected architecture of ADO.NET’s data access model.
What is ado rdo dao in visual basic?
What is connected architecture in ado.net?
Which namespaces are used for data access?
What are the namespaces used in ado.net for data access?
Why do we need ado.net?
What is connection pooling and what is the maximum pool size in ado.net connection string?
What are the various methods provided by the DataSet object to generate XML?
Explain executenonquery?
What is the use of connection object in ado.net?
What is the difference in an abstract class and an interface?
What two types of data providers does ADO.NET supply? What determines which one you should use?
