Insert / update in the same procedure?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,194
Messages
2,571,028
Members
47,626
Latest member
StevieLaut

Latest Threads

Top