declare @a nvarchar(2000);
declare @n DateTime;
set @n='2014-07-24 16:10:09.193'
set @a='select * from dbo.ERP_1_StockPrivate where expiryDate=CONVERT(DATETIME,'+@n+')'
exec (@a)
declare @a nvarchar(2000);
declare @n DateTime;
set @n='2014-07-24 16:10:09.193'
set @a='select * from dbo.ERP_1_StockPrivate where expiryDate='+@n+'
exec (@a)
俩出现问题一样
declare @n varchar(200);
set @n='2014-07-24 16:10:09.193'
set @a='select * from dbo.ERP_1_StockPrivate where expiryDate=CONVERT(DATETIME,'+@n+',120)'
exec (@a)
又出现'16' 附近有语法错误。这个错误了