May 23, 2011 at 1:17 pm
Please help me.
CREATE PROCEDURE [Test].[usp_EmployeeEmail_delete]
@Email_ID Bigint,
@Phone_ID Bigint
AS
Delete From Test.Email where Email_ID = @Email_ID and Phone_ID=@Phone_ID
If not exists (Select 1 from Test.EmployeeEmail where Email_ID=@Email_ID )
Begin
Exec Test.usp_EmployeeEmail_Delete @Email_ID
END
May 23, 2011 at 1:20 pm
What's the question?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2011 at 1:23 pm
How to make hard deletes using this procedure.
May 23, 2011 at 1:24 pm
Looks like you have it already. Are you getting an error?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 23, 2011 at 1:31 pm
venu0317 (5/23/2011)
How to make hard deletes using this procedure.
What do you mean by a 'hard delete'? The proc already looks like it deletes the rows. What's it not doing that you want it to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2011 at 1:59 pm
I got it...Thanks
May 23, 2011 at 2:11 pm
goushik (5/23/2011)
I got it...Thanks
Glad you got it. Can you share?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply