[SQL] Equivalent to sql%rowcount or @@rowcount

[vijaykumar M]

Hi All!

is it possible to get in sql number of rows affected by the sql last insert,

update or delete statement??

for eg,

oracle ------------- sql%rowcount.

sqlserver ------------ select @@rowcount.

Any help will be highly appreciated..

Thanks

Regards,

Vijay

---

Cool new emoticons. Lots of colour! On MSN Messenger V6.0