DB
icemedia
这个作者很懒,什么都没留下…
展开
-
check if filed exists in all tables in current DB
SELECTt.name AS table_name,SCHEMA_NAME(t.schema_id)AS schema_name,c.nameAS column_name , types.name, c.max_lengthFROMsys.tables AS tINNERJOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_IDinn原创 2016-06-13 17:49:37 · 370 阅读 · 0 评论 -
tsql default values, check current isolation level, check db object last update time
1) ALTER TABLE teseTable ADD column1 char(1) default 'S' with valueswith values will set values for for new column for existing rows. 2) check current isolation levelSELECT CASE原创 2016-06-14 16:19:27 · 589 阅读 · 0 评论