把数据库所有表varchar转换成nvarchar

declare @sql varchar(max)

set @sql=''

select @sql=@sql+ 'alter table ['+aa.tablename+'] alter column ['+aa.name+'] Nvarchar('+ aa.length +');'

from(

select top 50 a.name tablename,b.name, CONVERT(nvarchar(20),b.length) length

from sysobjects a,syscolumns b,systypes c

where a.id=b.id and b.xtype=c.xtype

and a.xtype='u' and c.name='varchar' and b.length>0

) as aa

print @sql

--exec(@sql)