M
Moe Sizlak
Hi,
I was wondering how I can execute and insert or an update based on a
condition? Should I pass a parameter in 'INSERT' or something to that
effect?
Moe
CREATE PROCEDURE UpdateEmailNote
@emailNote varchar(2000)
AS
SET NOCOUNT ON
Update tblEmailnote Set emailnote=@emailNote
SET NOCOUNT OFF
GO
I was wondering how I can execute and insert or an update based on a
condition? Should I pass a parameter in 'INSERT' or something to that
effect?
Moe
CREATE PROCEDURE UpdateEmailNote
@emailNote varchar(2000)
AS
SET NOCOUNT ON
Update tblEmailnote Set emailnote=@emailNote
SET NOCOUNT OFF
GO