＋设为首页 ＋添加到收藏夹
CREATE PROCEDURE test
WAITFOR TIME 12:50
IF EXISTS (SELECT name
FROM sysobjects
WHERE name=Ntext
AND Type=U)
DROP TABLE text
GO
CREATE TABLE text(textid smallint identity(1,1),
text varchar(116)
)
INSERT INTO text(tablename)
SELECT name
FROM sysobjects
WHERE type = u
GO
如果去掉第一句的话，这是一段完整的批处理，但是我想把它装入存储过程通过WAITFOR TIME调度执行，但是组织上存在问题，我想请问，怎么样组织才可以呢？谢谢。
CREATE PROCEDURE test
AS
BEGIN
WAITFOR TIME 12:50
IF EXISTS (SELECT name FROM sysobjects WHERE name=Ntext AND Type=U)
DROP TABLE [text]
CREATE TABLE [text](textid smallint identity(1,1),[text] varchar(116))
INSERT INTO [text]([text])
SELECT name FROM sysobjects WHERE type = u
END
GO
