How to Enter NULL

Question

In Sql server2016,I was pasting data into a table, how do i enter 'null' into a cell?
I try to some ways to get it, but failed.Hope to get support........

Answer 1

Hi，@newbie

Welcome to Microsoft T-SQL Q&A Forum!

If I understand correctly, if you want to insert null on the empty column, you can try 2 ways.
A simple method is to add '' directly. SQL will treat it as a string, or you can use Ctrl + 0 to implement it.

Best regards,
Bert Zhou

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You mean in SSMS data grid view?
Key combination <Ctrl> + 0

Answer 3

Thanks for Olaf's reply and Bert's reply. The solution works for me. Thanks again.