--获取SqlServer中表名称
SELECT Name FROM SysObjects Where XType='U' ORDER BY Name
--获取SqlServer中表结构
SELECT
syscolumns.name,systypes.name,syscolumns.isnullable, syscolumns.length
FROM
syscolumns, systypes
WHERE
syscolumns.xusertype
=
systypes.xusertype
AND syscolumns.id = object_id('你的表名')
判断中英文函数
获取非全英文
patindex('%[^0-9a-zA-Z]%',字段)>0
获取全英文
where not patindex('%[^0-9a-zA-Z]%',字段)>0
转载请注明原文地址: https://ju.6miu.com/read-3554.html
