34,576
社区成员
发帖
与我相关
我的任务
分享
IF (OBJECT_ID('proc_wldwqjyftj', 'P') IS NOT NULL)
DROP PROC proc_wldwqjyftj
GO
CREATE PROC proc_wldwqjyftj(@date1 DATETIME)
AS
BEGIN
SELECT sale,
NAME,
ye
FROM tes1
WHERE rq >= CreateDate
AND rq <= CONVERT(CHAR(10), @date1, 120)
END
GO
set @sql='select sale,name,ye from tes1 where rq>= CreateDate<=Convert(datetime,'+@date1+',120)' --这里字符串和datetime类型的@date1相加会出错,需要对@date1进行类型转换
if (object_id('proc_wldwqjyftj', 'P') is not null)
drop proc proc_wldwqjyftj
go
create proc proc_wldwqjyftj(@date1 datetime)
as
declare @sql varchar(8000)
begin
set @sql='select sale,name,ye from tes1 where CreateDate between ' + Convert(char(10), @date1 ,120) + ' and rq'
print (@sql)
end
go