SQL拼接语句中日期变量问题
下面这些语句,在运行的时候,总提示日期转换错误。
declare @ddd datetime
declare @ss varchar(8000)
set @ddd='2014-12-1'
set @ss ='select ' +@ddd
select @ss
试着日期转换,还是提示同样的错误,
declare @ddd datetime
declare @ss varchar(8000)
set @ddd='2014-12-1'
set @ss ='select CAST('+@ddd +' as datetime)'
select @ss
错误提示:
Msg 241, Level 16, State 1, Line 7
Conversion failed when converting date and/or time from character string.