SQL Server: Insert if column values are null

Question

I am newbie to SQL queries so sorry for this basic question.

I want to insert values into a table where column's value is null

I tried following

INSERT INTO SystemUsers(FilePath)
If @FilePath IS Null
values('C:\Users\Developer\Desktop\MvcApplication8\MvcApplication8\App_Data\Uploads\Lighthouse.jpg')

and

INSERT INTO SystemUsers(FilePath)
where FilePath IS Null
values('C:\Users\Developer\Desktop\MvcApplication8\MvcApplication8\App_Data\Uploads\Lighthouse.jpg')

But that didn't work, how can I insert default values in a column whether column's values are null?

jjchiw · Accepted Answer · 2013-09-20 14:05:16Z

9

Maybe what you want is the UPDATE command and not the insert something like this

UPDATE SystemUsers
SET FilePath = 'C:\Users\Developer\Desktop\MvcApplication8\MvcApplication8\App_Data\Uploads\Lighthouse.jpg'
WHERE FilePath is null

answered Sep 20, 2013 at 14:05

jjchiw

4,4301 gold badge33 silver badges32 bronze badges

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

1 Comment

Manoz Over a year ago

Thanks @jjchiw, I missed this.

M.Ali · Accepted Answer · 2015-08-15 01:35:40Z

0

UPDATE SystemUsers
    SET FilePath = 'C:\Users\Developer\Desktop\MvcApplication8\MvcApplication8\App_Data\Uploads\Lighthouse.jpg'
WHERE FilePath is null

Where clause normaly comes after the operation you are doing.

edited Aug 15, 2015 at 1:35

answered Sep 20, 2013 at 23:40

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Collectives™ on Stack Overflow

SQL Server: Insert if column values are null

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related