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’