Creating an Upsert Stored Procedure

Author	Message
Jeff Pagley	Jeff Pagley posted 17 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 223, Visits: 893	Hi SF Team, In the training course and manual was a stored procedure that was referred to called an Upsert. Could you please give me a T-SQL example of this sproc for updating/inserting a group records at one time. Thanks, Jeff
	Reply Like 0
Replies
Trent Taylor	Trent Taylor posted 17 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 7K	UPSERTs are designed more for creating or updating a single record. Now you may have a sproc that gets recusrivly called and updates a group of records, but generally UPSERts are designed for single record updates. You might look at the training manual as I believe there is a sample in there from Ben's session.
	Reply Like 0
Jeff Pagley	Jeff Pagley posted 17 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 223, Visits: 893	Thanks Trent. I will look in the training manual. Jeff
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Jeff Pagley - 17 Years Ago

UPSERTs are designed more for creating or updating a single record....

Trent L. Taylor - 17 Years Ago

Thanks Trent. I will look inthe training manual. Jeff

Jeff Pagley - 17 Years Ago

here you go CREATE PROC [dbo].[Book_upsert] @Book_pk int, @Title...

Bill Spack - 17 Years Ago

Thanks for the sproc. However, what I was looking for is a sproc which...

Jeff Pagley - 17 Years Ago

Jeff, it would look something like this: [codesnippet]@userPk INT,...

Trent L. Taylor - 17 Years Ago

Hi Trent, Thank you for taking the time to send me the example. It...

Jeff Pagley - 17 Years Ago

Login
Remember Me Reset Password Resend Validation Email Login