在sqlserver中执行print 'aaa' + CHAR(13) + 'bbb'即可验证
制表符: CHAR(9)
换行符: CHAR(10)
回车符: CHAR(13)
SELECT * FROM table_name where CHARINDEX(CHAR(10),column_name)>0
update table_name set column_name=replace(column_name,char(10),'') where CHARINDEX(CHAR(10),column_name)>0
制表符: CHAR(9)
换行符: CHAR(10)
回车符: CHAR(13)
SELECT * FROM table_name where CHARINDEX(CHAR(10),column_name)>0
update table_name set column_name=replace(column_name,char(10),'') where CHARINDEX(CHAR(10),column_name)>0
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30126024/viewspace-2125595/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30126024/viewspace-2125595/