Conditional insert sql server

Question

Let's consider this basic insert

insert into TableName (Col1,Col2,Col3) values (Val1,Val2,Val3)

i want this insert to be done only if Val1 !=null and Val3!=null How to accomplish this?

Sjuul Janssen · Accepted Answer · 2010-07-14 08:41:36Z

3

Is this what you're looking for?

IF (Val1 is not null AND Val3 is not null)
BEGIN 
    insert into TableName (Col1,Col2,Col3) values (Val1,Val2,Val3)
END

On second thought BeachBlocker's answer is quite nice too. I've modified it a little:

insert into TableName (Col1,Col2,Col3) select Val1,Val2,Val3 where Val1 is not null and Val3 is not null

answered Jul 14, 2010 at 8:41

Sjuul Janssen

1,8121 gold badge15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BeachBlocker · Accepted Answer · 2010-07-14 08:49:44Z

2

insert into TableName (Col1,Col2,Col3) select Val1,Val2,Val3 where Val1 is not null and Val3 is not null

answered Jul 14, 2010 at 8:42

BeachBlocker

2461 silver badge3 bronze badges