Equivalent to sql%rowcount or @@rowcount

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,