Check if exists in stored procedure with table type
Hi,
I have a stored procedure that inserts from a table type like the code below:
How can I check if xxxx already exists and instead Update that row?
I use this for inserting messages through BizTalk.
Best Regards
I have a stored procedure that inserts from a table type like the code below:
How can I check if xxxx already exists and instead Update that row?
I use this for inserting messages through BizTalk.
Best Regards
ALTER PROCEDURE [dbo].[InsertStuff]
(
@parStuff AS dbo.StuffTableType READONLY
)
AS
SET NOCOUNT ON
BEGIN
DECLARE
@id int
INSERT INTO dbo.Stuff(
[xxx],[xxxx],[xxxxx]
SELECT [xxx],[xxxx],[xxxxx]
FROM @parStuff;ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
INSERT INTO dbo.Stuff(
[xxx],[xxxx],[xxxxx]
SELECT [xxx],[xxxx],[xxxxx]
FROM @parStuff;