use TYDB_LZ Go CREATE procedure iscmp (@sql_command varchar(1000),@id varchar(4)) as --少了as begin if NOT exists(select 1 from sysobjects where name = '@id' and xtype='v') begin SET @sql_command ='CREATE VIEW @id AS SELECT iscmp FROM StateReport' EXEC(@sql_command) end end Go
Go
CREATE procedure iscmp
(@sql_command varchar(1000),@id varchar(4))
as --少了as
begin
if NOT exists(select 1 from sysobjects where name = '@id' and xtype='v')
begin
SET @sql_command ='CREATE VIEW @id
AS SELECT iscmp FROM StateReport'
EXEC(@sql_command)
end
end
Go