22,209
社区成员
发帖
与我相关
我的任务
分享存储过程出错~
使用存储过程创建视图，如果视图已存在，就不再创建，视图使用页面上用户填写的id来命名。
use TYDB_LZ
Go
CREATE procedure iscmp
(@sql_command varchar(1000),@id varchar(4))
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
错误消息：在关键字 'begin' 附近有语法错误。
请问谁知道怎么回事啊？
use TYDB_LZ
Go
CREATE procedure iscmp
(@sql_command varchar(1000),@id varchar(4))
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
错误消息：在关键字 'begin' 附近有语法错误。
请问谁知道怎么回事啊？
...全文
请发表友善的回复…
发表回复
WangZWang 2006-09-07
- 打赏
- 举报
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
playwarcraft 2006-09-07
- 打赏
- 举报
CREATE procedure iscmp @sql_command varchar(1000),@id varchar(4)
as
....
as
....
