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

2003-07-25 Thread Richard Huxton
On Friday 25 July 2003 07:04, vijaykumar M wrote: > 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. You can do this sort of thi

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

2003-07-24 Thread 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, VijayCool new emoticons. Lots of colo