USE master
go
CREATE PROCEDURE createMyGlobalTables AS
CREATE TABLE ##globalTemporary1
(-- Blah blah (insert DDL here)
CREATE TABLE ##globalTemporary2
(-- Blah blah (insert DDL here)
--and so on….
CREATE TABLE ##globalTemporaryn
(-- Blah blah (insert DDL here)
go
EXEC sp_procoption 'createMyGlobalTables', 'startup', 'true'
No comments:
Post a Comment