Click here to Skip to main content
14,449,906 members
Rate this:
Please Sign up or sign in to vote.
See more:
I have an application in vb net but in the fields which are set allow NULLS I cannot delete the values even from sql management studio, it is strange because nulls field can contain no value.

What I have tried:

to delete an allow null field value from sql management.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Programmatically:
UPDATE [TheTable] SET [TheColumn] = NULL WHERE [TheId] = AFilter;

Otherwise, from SSMS, select the value in a nullable column and press Ctrl + 0.
   
Comments
Maciej Los 10-Feb-20 2:52am
   
5ed!

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100