insert/update in one stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

insert/update in one stored procedure

Author

Topic

tpiazza55
Posting Yak Master

162 Posts

Posted - 2007-07-30 : 10:33:16

Hi:

I am trying to write a stored procedure that when passed a name, value it will

1. update the record if the name exists
2. create a new record if it doesnt

how would i do this?

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2007-07-30 : 10:39:48

IF exists(select * from table1 where [name] = @name)
BEGIN
"UPDATE CODE HERE"
END
ELSE
BEGIN
"INSERT CODE HERE"
END

Jim