Int field in SQL Server not accepting blank information
I am working with SQL server 2000 and I have a table that has int fields in it. When I submit a form and insert the data into the fields, the int field will not accept empty information. I have set the field to allow nulls when I designed the table. I have written the code now to submit a 0 in the field if the user leaves the text box blank that corresponds to the field in the database, but wondering if there is a way to SQL Server accept blank data in an integer field.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.