Conditional sql server input

Question

Consider this main insert

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

I want this insertion to be done only if Val1! = Null and Val3! = Null How to do this?

Answer 1

Is this what you are looking for?

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

At a second glance, BeachBlocker's answer is also very nice. I changed it a bit:

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

Answer 2

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