存储过程和一般sql语句，结果不同。。。

[baisun]

存储过程：
CREATE PROCEDURE [dbo].[dd]
@d varchar
AS
declare @sql varchar(1000)
set @sql='select * from re where rtrim(redate)=cast('+@d+' as datetime)'
exec (@sql)
GO
执行dd '2005-04-03'无结果

一般sql语句：
select * from re where rtrim(redate)=cast('2005-04-03' as datetime)
得到了正确结果。

存储过程那里不对呢？

[fengfangfang]

存储过程
CREATE PROCEDURE [dbo].[dd]
@d varchar
AS
declare @sql varchar(1000)
set @sql='select * from re where rtrim(redate)=cast('''+@d+''' as datetime)'
exec (@sql)
GO

[paoluo]

CREATE PROCEDURE [dbo].[dd]
@d varchar(50) --这里加上字符串的长度
AS
declare @sql varchar(1000)
set @sql='select * from re where rtrim(redate)=cast('''+@d+''' as datetime)' --这里'改为'''
exec (@sql)
GO

[wyb0026]

CREATE PROCEDURE [dbo].[dd]
@d varchar --你这个Varchar是多长，是不是应该给出来呀 否则可不对呀
AS

[xluzhong]

CREATE PROCEDURE [dbo].[dd]
@d varchar(1000) ---默认是1
AS
declare @sql varchar(1000)
set @sql='select * from re where rtrim(redate)=cast('''+@d+''' as datetime)'
exec (@sql)
GO