Sunday, February 19, 2012

Inserting Null values

Hi,
I am trying to insert null values into sql server from my access from. I am using sql statement. But it says 'Syntex error in Insert statement'. When i remove null values it works fine? How can I insert null values into a table?
Any help will be highly appreciated.It would help if you post the statement...|||Use SQL Pass-Through Query:

INSERT INTO Table1 ( id, name ) values(13, null);|||If your table accepts null in the field (name) then you don't need to mention that in your isert statment. Just use:

INSERT INTO Table1 (id) values(13);

No comments:

Post a Comment