5,930
社区成员
发帖
与我相关
我的任务
分享怎样建立一个删除视图的存储过程?
CREATE PROCEDURE DelView
AS
BEGIN
Dorp View business_View
END
parameters:
View_Name Input Char(12);
出现"General SQL error.Token unknown - line 4, char 6
View"是怎么意思?
AS
BEGIN
Dorp View business_View
END
parameters:
View_Name Input Char(12);
出现"General SQL error.Token unknown - line 4, char 6
View"是怎么意思?
...全文
请发表友善的回复…
发表回复
kakaxixi_008 2002-02-07
- 打赏
- 举报
你的 Drop 写错了(不是Dorp)
同时你最好先判断存不存在
if exists (select * from sysobjects where id = object_id(business_View '))
drop View business_View
同时你最好先判断存不存在
if exists (select * from sysobjects where id = object_id(business_View '))
drop View business_View
