sqlserver查詢一張表所有欄位是否含製表符、換行符、回車符

製表符： CHAR(9)
換行符： CHAR(10)
回車符： CHAR(13)




select 'SELECT COUNT(*) FROM 表名 where CHARINDEX(CHAR(9),"'+SysColumns.name+'")>0 union all'
from sysobjects inner join SysColumns on sysobjects.id=SysColumns.id 
where sysobjects.name='表名'


select 'SELECT COUNT(*) FROM 表名 where CHARINDEX(CHAR(10),"'+SysColumns.name+'")>0 union all'
from sysobjects inner join SysColumns on sysobjects.id=SysColumns.id 
where sysobjects.name='表名'


select 'SELECT COUNT(*) FROM 表名 where CHARINDEX(CHAR(13),"'+SysColumns.name+'")>0 union all'
from sysobjects inner join SysColumns on sysobjects.id=SysColumns.id 
where sysobjects.name='表名'