DELETE FROM [dbo].[Supplier] WHERE (([id_supplier] = @Original_id_supplier) AND ([name_organization] = @Original_name_organization)) SELECT id_supplier, name_organization FROM dbo.Supplier UPDATE [dbo].[Supplier] SET [name_organization] = @name_organization WHERE (([id_supplier] = @Original_id_supplier) AND ([name_organization] = @Original_name_organization)); SELECT id_supplier, name_organization FROM Supplier WHERE (id_supplier = @id_supplier)