select @@error'Error' select @@rowcount'Rows'

How do you find the error, how can you know the number of
rows effected by last SQL statement?

Question Posted / chandra rekha

Answer Posted / chandra rekha

select @@error'Error'
select @@rowcount'Rows'

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql server agent and what are the two modes of authentication in sql server?

1108

What is query optimizer in sql server?

1072

Can we add an identity column to decimal datatype?

1040

How to delete a login name in ms sql server?

1125

What are the different acid properties?

1117

Write a sql query to sort on different column name according to the parameters passed in the function?

958

What is updatable resultset?

1070

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1060

Why variables called the most powerful component of ssis?

1122

Explain the ways to controlling cursor behavior?

967

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2074

Difference between Sql server reporting services and Crystal reports?

175

Is sql server a database?

1035

How will you find out if there are expensive SQL statements running or not?

1069

What is resource db in sql server?

1056