user8721624 wrote:It should be something like:
Also, is this the correct SQL to add a new colun "flag" to table tblLocations:
ALTER TABLE tblLocations
ALTER COLUMN flag bit
I guess you can use CHAR(1) datatype to hold this data. Also you can create a check constraint on the flag_bit column to make sure that only 1 and 0 can be stored in the column.
ALTER TABLE tbllocations ADD FLAG_BIT CHAR(1)