Answer the question
In order to leave comments, you need to log in
How to validate Insert data before inserting into cursor?
The question is this:
Data is selected from tables and added to cursor variables:
INSERT into [Myserver\my_instance].Special_table.dbo.stat (my_col1,my_col2,my_col3,my_col4,my_col5,my_col6,my_col7) VALUES (@var1, @var2, @var3, @var4, @var5, @var6, @var7);
Answer the question
In order to leave comments, you need to log in
EXISTS .
IF NOT EXISTS (SELECT * FROM [Myserver\my_instance].Special_table.dbo.stat WHERE ([my_col1] = @var1) AND ([my_col2] = @var2))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question