var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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....
It's a Great Day for America everybody!
dbforums Yak CorralRadio 'Rita
dbForums Member List
I'm Good Once as I ever was
The physical order of data in a database has no meaning.
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);
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors