Got an issue in the SQL table that it is by default
inserting NULL values but I need blank values instead NULLs.
You would see this when you right click on table on object explorer.
Right Click on table name and click design and highlight the column you are
looking for and see the column properties at the below. Change the Default
Value or Binding from blank to ‘’ (single quotes without empty space in the
middle)
Verify the fix by inserting new records in the table and
observe.
No comments:
Post a Comment