存储过程创建数据库、表，要用事务，各位大虾帮帮忙啊！

Question

USE master
GOIF EXISTS(SELECT * FROM SYSOBJECTS WHERE name='CREATEDB_1')
DROP PROC CREATEDB_1
GO
CREATE PROC CREATEDB_1
AS
BEGIN
IF EXISTS(SELECT * FROM SYSDATABASES WHERE name='TEST')
DROP DATABASE TEST
CREATE DATABASE TEST

IF EXISTS(SELECT * FROM SYSOBJECTS WHERE name='TEST.DBO.MYTEST_1')
DROP TABLE TEST.DBO.MYTEST_1
CREATE TABLE TEST.DBO.MYTEST_1
(
ID INT IDENTITY(1,1) PRIMARY KEY,
NAME NVARCHAR(20) NOT NULL
)
END
GOEXEC CREATEDB_1

Answer 1

    
        IF EXISTS(SELECT * FROM TEST.DBO.SYSOBJECTS WHERE name='MYTEST_1')