SQL

SQL Transaction Rollback - create sample table CREATE TABLE result ( s_id int NULL, s_name varchar(50) NULL, m1 int NULL, m2 int NULL, m3 int NULL ) - whenever we update the data using s_id,if the count of record is more than one,the transaction will be rollback create proc test ( @s_id int, @s_name varchar(20), @m1 int, @m2 int, @m3 int ) as begin transaction begin update result set s_name=@s_name,m1=@m1,m2=@m2,m3=@m3 where s_id=@s_id if @@rowcount >= 2… More information...

User:	Jayaramchandran Manickam
Page:	saicodes.webnode.com (?)