· 8 years ago · May 03, 2018, 09:36 PM
1USE [DATABASENAME]
2GO
3
4SET ANSI_NULLS ON
5GO
6SET QUOTED_IDENTIFIER ON
7GO
8
9ALTER PROCEDURE [dbo].[Sproc]
10@Id int
11AS
12BEGIN
13
14SET NOCOUNT ON;
15
16IF NOT EXISTS (SELECT name FROM sys.databases WHERE name =
17N'Name')
18
19create database Name;
20
21GO
22
23CREATE TABLE [Name].[dbo].[Account](
24[Id] [int] IDENTITY(1,1) NOT NULL,
25[AccountId] [int] NOT NULL
26);