没有口水与汗水，就没有成功的泪水。早安！有时，我们以为赢了，其实，我们输了！因为，我们赢了＂面子＂，却输了＂里子＂！早安！
select a.name, o.name AS TableName, o.type, a.id, o.object_id, o.schema_id
FROM sys.syscolumns AS a INNER JOIN sys.systypes AS b ON a.xtype = b.xtype
AND b.name = 'nvarchar'
INNER JOIN
sys.objects AS o ON a.id = o.object_id
WHERE (o.type = 'u')
AND (o.schema_id = 1)
本文sqlserver中查找特定类别的列的写法到此结束。生活不会惯着你，想要不被抛弃，必须自己争气。小编再次感谢大家对我们的支持！