How to enter 'NULL' into SSMS cell?

sql-server ssms-2012
Michel de Ruiter picture Michel de Ruiter · May 19, 2014 · Viewed 14.9k times · Source

In SQL Server Management Studio 2012, I was typing/pasting data into a table (via Edit Top 200 Rows). Whenever I typed/pasted NULL in a cell, a NULL value was inserted. Apparently it thought I meant the NULL value instead of the 'NULL' text. Which didn't work, as my column wasn't nullable...

Now how do I enter the 'NULL' text into a cell?

If I wanted to insert the NULL value, I would have pressed Ctrl+0...

Answer

qxg picture qxg · May 21, 2014

Just enter 'NULL' (with single quote mark) into cell, SSMS will trim leading and ending single quote mark and save it as string 'NULL'.

Without single quote mark, SSMS will treat input as NULL.

Related questions

Where is the SQL Query Analyzer in SQL Server Management Studio 2012

I have some SQL thats getting run and it is taking to long to return the results / parse / display, etc. application. I have SQL Server Management Studio 2012 installed.but i am not able to find SQL Query Analyser. Any Input …

Read More
SELECT * FROM Linked MySQL server

I have a SQL Server 2012.(120.120.55.15) Today I linked MySQL server(120.120.55.30) to my SQLServer and gave it a name "MYSQL". In Object Explorer everything seems fine. I can see MySQL server's database "exampleDataBase" and tables in it. But when I try …

Read More
Source Type 200 in SQL Server Import and Export Wizard?

I am trying to import data from one database in a server to a new table in a different server, using SQL Server import and Export Wizard. (SQL Server Management Studio 2012) In the wizard, I checked "Write a query to …

Read More