Question

在存储过程中怎样创建多个视图？

在存储过程中怎样创建多个视图？有列子说明的话，更好，谢谢啦

Answer 1

你的SQL语句有问题，SUM(QUETITY) QUETITY 是 SUM(QUETITY) AS QUETITY 吧 CREATE PROCEDURE [dbo].[存储过程名] @GHSNAME nvarchar(?) AS BEGIN EXEC('IF EXISTS (SELECT * FROM sysviews WHERE object_id = ''[dbo].[视图名]'') DROP VIEW [dbo].[视图名]') EXEC('CREATE VIEW [dbo].[视图名] AS SELECT [PDNAME],SUM(QUETITY) AS [QUETITY] FROM RCXXJL WHERE [PDNAME]=''显示器'' AND [GHSNAME]='''+@GHSNAME+'''') END