Skip to content

Instantly share code, notes, and snippets.

@nisar1
nisar1 / transaction in sp mssql.sql
Last active August 29, 2015 13:57
transaction in sp mssql
create procedure uspContactPersonDeleteSingleItem
@id int
as
begin tran
delete from address where contactpersonid = @id;
if @@ERROR <> 0
begin
rollback tran
return -1
end