![--查询nvarchar(max)的表和字段 --查询nvarchar(max)的表和字段](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
--查询nvarchar(max)的表和字段
select 'insert into #tempTabelInfo select '''+d.name+''', '''+a.name+''', max(len('+a.name+')) as '+d.name+'的'+a.name+' from '+d.name+' with(nolock) ' , d.name as tabelname,a.name,b.name FROM syscolumns a,
systypes b,sysobjects d
WHERE a.xtype=b.xusertype and a.id=d.id
and d.xtype='U' and a.length<0