2,498
社区成员
发帖
与我相关
我的任务
分享这样的存储过程怎么不行啊？
CREATE PROCEDURE xg_droptable
@xg_tablename VARCHAR(20)
AS
BEGIN
IF EXISTS(SELECT name FROM sysobjects WHERE name=@xg_tablename and type='U')
DROP TABLE @xg_tablename
END
@xg_tablename VARCHAR(20)
AS
BEGIN
IF EXISTS(SELECT name FROM sysobjects WHERE name=@xg_tablename and type='U')
DROP TABLE @xg_tablename
END
...全文
请发表友善的回复…
发表回复
jin_zai 2003-10-01
- 打赏
- 举报
写成这样就可以了
CREATE PROCEDURE xg_droptable
@xg_tablename VARCHAR(20)
AS
BEGIN
IF EXISTS(SELECT name FROM sysobjects WHERE name=@xg_tablename and type='U')
exec('DROP TABLE '+@xg_tablename)
END
CREATE PROCEDURE xg_droptable
@xg_tablename VARCHAR(20)
AS
BEGIN
IF EXISTS(SELECT name FROM sysobjects WHERE name=@xg_tablename and type='U')
exec('DROP TABLE '+@xg_tablename)
END
