CREATE PROCEDURE dt_bh
@dw varchar(30),--//查询表变量
@ksrq_1 datetime --//开始日期
@jksrq_1 datetime -- //结束日期
as
declare @s nvarchar(4000)
set @s='select * from ['+@dw+'] where 日期字段 between '''+convert(varchar,@ksrq_1,120)+''' and '''+convert(varchar,@jksrq_1,120)+''''
exec(@s)
@dw varchar(30),--//查询表变量
@ksrq_1 datetime --//开始日期
@jksrq_1 datetime -- //结束日期
as
declare @s nvarchar(4000)
set @s='select * from ['+@dw+'] where 日期字段 between '''+convert(varchar,@ksrq_1,120)+''' and '''+convert(varchar,@jksrq_1,120)+''''
exec(@s)
set @str='select * from '+@dw+' where fieldname between '''+cast(@ksrq_1 as varchar(20))+ ''' and ''' +cast(@jksrq_1 as varchar(20))+ ''''
exec(@str)