在Strored Procedure中查看 [英] view in Strored Procedure

问题描述

ALTER proc [dbo].[sp_chart1](@from as varchar(30),@to as varchar(30))
as 
begin
DECLARE @ft datetime
DECLARE @tt datetime
set @ft=CONVERT(datetime,@from)
set @tt=CONVERT(datetime,@to)
CREATE VIEW VIEW11 AS SELECT Time_Sheet.entry_by,Time_Sheet.duration,Module_Master.module_name FROM Time_Sheet INNER JOIN Module_Master ON Time_Sheet.module_id=Module_Master.module_id where Time_Sheet.create_date>=@ft and Time_Sheet.create_date<=@tt
end

注意： -

上面的存储过程给出了错误plz帮帮我的朋友..

note:-
the above stored procedure gives error plz help me friends ..

推荐答案

为什么要更改视图？难道不是您在该视图上执行的选择的日期部分吗？

Why change the view? Isn''t the date part of the select you would perform on that view?

SELECT ... 
  FROM VIEW11 
  WHERE Time_Sheet.create_date>=@ft 
  AND Time_Sheet.create_date<=@tt

祝你好运！

Good luck!

这篇关于在Strored Procedure中查看的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！