|
|
|
Junior Member
 
Group: Forum Members
Last Login: 11/18/2009 10:51:34 AM
Posts: 10,
Visits: 36
|
|
|
I am periodically updating one of my test table. When I insert a new record one of the fields is NULL. Can anyone tell me how to insert a NULL value to the field.?
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/23/2009 8:01:21 AM
Posts: 44,
Visits: 371
|
|
You can insert NULL values like below :
insert into tablename values (123,NULL,NULL);
Here 2nd and 3rd columns will be inserted as NULL values.
Regards,
Ansh
|
|
|
|