SQL中用+如: declare @s varchar(100)declare @d varchar(16)set @d = '2012/2/10'set @s = 'select * from tablename where datafield = '" + @d + "'"