ALTER PROCEDURE gDatabyTime
@DateF DateTime,
@DateT DateTime
AS
declare @sqlstr nvarchar(400)set @sqlstr = 'select * from [order] where Order_Get between '''+Convert(nvarchar(10),@DateF,120)+''' and '''+Convert(nvarchar(10),@DateT,120)+''''exec sp_executesql @sqlstr
@DateF DateTime,
@DateT DateTime
AS
declare @sqlstr nvarchar(400)set @sqlstr = 'select * from [order] where Order_Get between '''+Convert(nvarchar(10),@DateF,120)+''' and '''+Convert(nvarchar(10),@DateT,120)+''''exec sp_executesql @sqlstr
@DateF DateTime,
@DateT DateTime
AS
BEGIN
declare @sqlstr nvarchar(400)
set @sqlstr = 'select * from [city_sanguo_count] where dt between Convert(varchar(10),@DateF,120) and Convert(varchar(10),@DateT,120)'
exec sp_executesql @sqlstr,N'@DateF DateTime,@DateT DateTime',@DateF ,@DateT
END
alter PROCEDURE P_gDatabyTime
@DateF DateTime,
@DateT DateTime
AS
BEGIN
declare @sqlstr nvarchar(4000)
set @sqlstr = 'select * from [order] where Order_Get between Convert(varchar(10),@DateF,120) and Convert(varchar(10),@DateT,120)'
exec sp_executesql @sqlstr,N'@DateF DateTime,@DateT DateTime',@DateF ,@DateT
END