adding default column with type BIT and default value as Y

• Smash125

  Hall of Fame

  Points: 3562

  More actions

  April 5, 2019 at 9:51 am

  #2852708

  i want to add new column test to the table contact with type of bit with default value Y please let me know

• Thom A

  SSC Guru

  Points: 99130

  More actions

  April 5, 2019 at 11:12 am

  #2856716

  Cross post: https://www.sqlservercentral.com/forums/topic/adding-default-column-with-type-bit-and-default-value-as-y-2

  Please don't post questions twice (especially when it's different versions of SQL Server). Please direct answers to the link above.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk