THANKS FOR YOUR REPLY..
My Question in more detail:
-------------------- Task 1 ----------------------
--[tEmployee]
CREATE TABLE [dbo].[tEmployee]( [empNo] [int] NOT NULL, [empName] [varchar](50) NULL,
CONSTRAINT [PK_tEmployee] PRIMARY KEY CLUSTERED ([empNo] ASC)
--Stored Procedure 'X'
DELETE FROM [dbo].[tEmployee] WHERE...