icemedia的专栏

SELECTt.name  AS table_name, SCHEMA_NAME(t.schema_id)AS schema_name, c.nameAS column_name , types.name, c.max_length FROMsys.tables AS t INNERJOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID inn

1) ALTER TABLE teseTable ADD column1 char(1)   default 'S'  with values with values will set values for for new column for existing rows.  2) check current isolation level SELECT CASE