Xerratus - Setting a cell to NULL when editing data in SQL within a tableview

Wednesday, November 22, 2006

Setting a cell to NULL when editing data in SQL within a tableview

Somebody recently asked me this question and I thought that a some others out there might not know this little trick; SQL gurus please ignore:

When editing data in a table view from within SQL Enterprise Manager (2000 or 2005) you can NULL the field by hitting Ctrl+0 when the cell has focus. Deleting the data completely does not do it. Typing in "NULL" does not do it either.

Wednesday, November 22, 2006 @ 07:02 PM (-08:00) Pacific Standard Time

Comments (0)

tags: Programming

admin: Edit | Remove

Name
E-mail
Home page

	Remember Me
Comment (Some html is allowed: `a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u`) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview