SQL Server备忘录

一些杂七杂八的记录，不重要，只是记录

符号	含义
’	变量标识符
“	转义符，包括转义关键字
=	赋值/判断相等

查询表信息

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 = ''