![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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_length FROMsys.tables AS t INNERJOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID inn原创 2016-06-13 17:49:37 · 372 阅读 · 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 values with values will set values for for new column for existing rows. 2) check current isolation level SELECT CASE原创 2016-06-14 16:19:27 · 593 阅读 · 0 评论