Hi Guys
I would like to do the following
DECLARE @ItemId int
SET @ItemId = 100
DELETE FROM [Table] WHERE Id=1
IF DELETE Result is true or equal to 1
EXEC('mystoreProc ' +@ItemId)
Thank you
Hi Guys
I would like to do the following
DECLARE @ItemId int
SET @ItemId = 100
DELETE FROM [Table] WHERE Id=1
IF DELETE Result is true or equal to 1
EXEC('mystoreProc ' +@ItemId)
Thank you
hi
hope this helps
DECLARE @ItemId int
SET @ItemId = 100
DELETE FROM [Table] WHERE Id = 1
IF @@ROWCOUNT = 1
BEGIN
EXEC mystoreProc @ItemId
END