目录
一. 清除数据中的回车符、换行符、制表符
在SQL Server中,回车符的AASCII码是13,换行符的ASCII码是10,制表符t的ASCII码CHAR(9)
1.1,回车符
查找有回车符的内容
select id,theme from TableName where charindex(char(13),theme) > 0
清除回车符
update TableName set theme=replace(theme, char(13),'') where 1=1
1.2,换行符
查找有换行符的内容
select id,theme from TableName where charindex(char(10),theme) > 0
清除换行符
update TableName set theme=replace(theme, char(10),'') where 1=1
1.3,制表符t
查找有制表符的内容
select id,theme from TableName where charindex(char(9),theme) > 0
清除制表符
update TableName set theme=replace(theme, char(9),'') where 1=1
1.4,回车换行符
查找有回车换行符的内容
select id,theme from TableName where charindex(char(13) + char(10),theme) > 0
清除回车换行符
update TableName set theme=replace(theme,char(13) + char(10),'') where 1=1
转自 http://www.dongchuanmin.com/archives/690.html
二. 查询
2.1 根据条件查询
SELECT * FROM tblOriginalRecordDate WHERE PID>1 OR PID<5
2.2 根据条件查询返回特定参数
SELECT 参数 FROM tblOriginalRecordDate WHERE RecordNumber='159033'
2.3 根据条件查询返回特定参数并按照**排序,比如时间
SELECT 参数 FROM tblOriginalRecordDate WHERE RecordNumber='159033' ORDER BY GenerationTime
2.3 根据条件查询,去除重复的返回的参数
select DISTINCT (InstrumentProgramme) from dbo.CorrectMeterProgramme where CaliberDN='400'OR CaliberDN='500'
三. 根据条件删除
DELETE FROM OriginalRecordDateBig WHERE PID>1
四. 根据条件删除
ORDER BY GenerationTime
四. 根据条件修改项
update dbo.CorrectMeterProgramme set PointDeviation='0.25' WHERE DeliveryNum='H14218336'