Shortcut key for inserting Null value
-
Hi All
I have used this before but cannot remember what it is. There is a shortcut key for inserting a null value into a field. Any one know?
Thanks,
Blaine
-
In enterprise manager :
Ctrl-0
in tsql :
update yourtable set yourfield = null
-
Thanks Remi
Much Appreciated
-
NP. It's really annoying when you forget this trick and got only 1-2 cells to edit. Then you got to build a full update statement for just that
. -
Please remember to use proper syntax through out your scripts for testing nulls;
Avoid using:
where field = null
This is not the same as:
where field is null
Regards,Coach James
-
set yourfield = null
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply