有没有办法在存储过程中创建视图？急！

[cuiweibing]

看一下我这个，不行

CREATE PROCEDURE UpClassIntegralYear
( @begin_dt char(19),
@end_dt char(19) )
AS
IF EXISTS(SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME='ViewClassIntegralYear')
DROP VIEW ViewClassIntegralYear
GO
CREATE VIEW ViewClassIntegralYear(GRADE_YEAR,CLASS_CODE,SHORT_NAME,TOTAL_SCORE)
AS
SELECT CLASS_CODE, SCORE
FROM dbo.CwbClassIntegral
WHERE (CREATE_DT BETWEEN ''+@begin_dt+'' AND ''+@end_dt+'')
GO

[cuiweibing]

自己顶一下

[ziping]

" 双引号？这个好象是不可以吧

[cuiweibing]

应该怎么写呀？
帮忙改一下行吗？

[mengzulin]

CREATE procedure dbo.TEST
as
BEGIN
DECLARE @sql VARCHAR(1000)
if NOT exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MZL_AA]') and OBJECTPROPERTY(id, N'IsView') = 1)
BEGIN
SET @sql ='CREATE VIEW dbo.MZL_AA
AS SELECT [ID], [a] FROM [test].[dbo].[aa]'
EXEC(@sql)
END
END
GO
DECLARE @RC int
EXEC @RC = [test].[dbo].[createview]
GO

[cuiweibing]

是不是不能在存储过程的sql语句中使用CREATE VIEW？

[zjcxc]

CREATE PROCEDURE UpClassIntegralYear
( @begin_dt char(19),
@end_dt char(19) )
AS
IF EXISTS(SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME='ViewClassIntegralYear')
DROP VIEW ViewClassIntegralYear
EXEC('
CREATE VIEW ViewClassIntegralYear(GRADE_YEAR,CLASS_CODE,SHORT_NAME,TOTAL_SCORE)
AS
SELECT CLASS_CODE, SCORE
FROM dbo.CwbClassIntegral
WHERE (CREATE_DT BETWEEN '''+@begin_dt+''' AND '''+@end_dt+''')')
GO

[lwugui]

CREATE PROCEDURE dumpENGINEdata
@createtime varchar(40)
AS
EXEC(' create view test1 as select fd_fileid from tb_engine_filecommon where substring(FD_FILEID,11,8)<"@createtime"')
GO