SQL Related Notes

• integer columns can’t accept “empty” value event it allow “NULL”.
  
  • This statement will fail:
    insert into table (column1, column2)
    select , N’test’
  • This statement will work:
    insert into table (column1, column2)
    select null, N’test’