sql 中的 转义符

[jason_liu24]

/**** date_Park 数据导入 ****/

delete from date_Park where [Date] = @date

--VehicleIn
set @sql = 'insert into date_Park(VehicleIn,[Date]) '
set @openquery = 'select VehicleIn,tm from openquery([ACS_PARKING],''select COUNT(1) VehicleIn,CONVERT(varchar(12),crdtm,23) as tm from ACS_Parking20000.dbo.Tc_UserCrdtm
where convert(varchar(12),crdtm,23) between '''''+@date+''''' and '''''+@date+''''' and inorout = 0 and (userTypeid = 1 or userTypeid = 6)
group by CONVERT(varchar(12),crdtm,23)'')'

exec (@sql+@openquery)

百度过转义符的使用，反复思考还是不理解为啥@date 前后会有5个单引号，烦请前辈指点。

[卖水果的net]

字符串要用单引号包起来，如果字符串本身就含有单引号，要用 2 个单引号表示 1 个单引号。 你把你最终拼接成的 sql 语句,print 一下，一看就明白。