一些杂七杂八的记录,不重要,只是记录
符号 | 含义 |
---|---|
’ | 变量标识符 |
“ | 转义符,包括转义关键字 |
= | 赋值/判断相等 |
查询表信息
SELECT ta.name,co.name,co.max_length,sco.DATA_TYPE
FROM sys.tables ta WITH(NOLOCK)
LEFT JOIN sys.columns co WITH(NOLOCK) on ta.object_id = co.object_id
LEFT JOIN INFORMATION_SCHEMA.COLUMNS sco WITH(NOLOCK) on sco.COLLATION_NAME = co.name and sco.TABLE_NAME = ta.name
where ta.name = ''
and co.name = ''