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

How to download and install the scaled-down database adventureworkslt?

991

Can I use sql azure as a backup with log shipping or database mirroring?

156

Write down the syntax and an example for create, rename and delete index?

982

Explain about remote stored procedure?

1008

How to get all stored procedures in sql server?

1001

What is explicit cursors?

1071

Explain how many normalization forms?

1031

What is sql server query analyzer?

1030

What is log cache in sql server?

1040

Define msdb database?

1015

Write an sql query to find first weekday of the month?

916

Explain the steps needed to create a scheduled job?

930

What is the difference between a local and a global temporary table?

1117

Where the sql logs gets stored?

984

What is primary key, unique key, and foreign key?

976