改为这样即可CREATE PROCEDURE dbo.TSumsend_allbytype
@begin datetime,@end datetime
AS
select * from table1 where date_ak between @begin and @end
GO
不需要使用动态SQL语句。
@begin datetime,@end datetime
AS
select * from table1 where date_ak between @begin and @end
GO
不需要使用动态SQL语句。
@begin datetime,@end datetime
AS
select * from table1 where date_ak between @begin and @end
GO
set @sql='select * from table1 where date_ak between '+''''+convert(varchar(18),@begin,126)+''''+' and '+''''+convert(varchar(18),@end,126)+''''exec(@sql)
@begin datetime,@end datetime
AS
declare @sql varchar(8000)
set @sql='select * from table1 where date_ak between '''+convert(varchar(19),@begin,120)+''' and '''+convert(varchar(19),@end,120)+''''
exec @sql