Enter Null Values for text Column of SQL Server

Question

1.00/5 (1 vote)

See more:

SQL-server-2000

SQL-Server

Enter Null Values for text Column of SQL Server

Posted 28-May-14 23:37pm

tanugarg

Add a Solution

Comments

CHill60 29-May-14 5:38am

And your question is?

Soft009 29-May-14 5:40am

where is the question?

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-05-28T23:40:00

Solution 1

Try:

SQL

INSERT INTO MyTable (MyColumn) VALUES (NULL)

Posted 28-May-14 23:40pm

OriginalGriff

soumyajayaraj · Answer 2 · 2014-05-28T23:43:00

Solution 2

If the string column is nullable

Insert INTO table_name (id, name) value (1,NULL)

Posted 28-May-14 23:43pm

soumyajayaraj

Comments

CHill60 29-May-14 5:51am

Worth mentioning that if id is set up as an autoincrement identity column then you should not try to insert it

CHill60 · Answer 3 · 2014-05-28T23:52:00

Solution 4

For completeness, if you want to update an existing row then you would use this construct

UPDATE MyTable SET MyColumn=null WHERE ID = 2 -- or whatever

Posted 28-May-14 23:52pm

CHill60

**Nirav Prabtani** · Answer 4 · 2014-05-28T23:46:00

Solution 3

Check in database is this column allow null or not if yes then try
Solution 1
else allow null value to this column

Posted 28-May-14 23:46pm

Nirav Prabtani