Skip to navigation
How to mimic a upsert(update or insert) query with a mssql store procedure
16.02.16
CREATE PROCEDURE [dbo].[my_upsert] @style varchar(max), @machine_code varchar(max), @pcs_per_tree varchar(max) AS IF EXISTS (SELECT * FROM MYDB WHERE style = @style) BEGIN UPDATE [SL].[dbo].[MYDB] SET machine_code = @machine_code ,pcs_per_tree = @pcs_per_tree WHERE style = @style RETURN 1 END ELSE BEGIN INSERT INTO MYDB] ( style, machine_code, pcs_per_tree ) VALUES( @style, @machine_code, @pcs_per_tree ) RETURN 1 END
https://www.microsoft.com/en-us/server-cloud/products/sql-server/
Reply
Anonymous
Information Epoch 1762500454
Data dominates.
Home
Notebook
Contact us
