CREATE Procedure [dbo].[Clerk_Delete] @clk_Id int As Begin Begin Try Begin Tran a Delete From Clerk Where clk_Id = @clk_Id Commit Tran a; End Try Begin Catch Rollback Tran a; End Catch End
CREATE Trigger [dbo].[Clerk_Insert_Trigger] on [dbo].[Clerk] For delete As --declare @a int; --select @a = Clerk.clk_Id from Clerk If exists (Select HokmeKargozini.clk_Id from HokmeKargozini ) Begin print 'You don''t remove this clerk '; ROLLBACK tran a; End else Begin print 'It''s removed '; End
DECLARE @id INTSELECT @id = COALESCE(clk_Id,0)FROM HokmeKargozini)IF (@id = 0)PRINT 'Doesn''t exists'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)