34,576
社区成员
发帖
与我相关
我的任务
分享
-- 待操作数据库
DECLARE @dbName nvarchar(20);
SET @dbName='as2018';
-- 当前数据库
DECLARE @curdbName nvarchar(20);
SET @curdbName=(SELECT DB_NAME());
PRINT(@curdbName)
IF @curdbName=@dbName
Begin
PRINT '已选中目标数据库 ' + @dbName;
/****** Object: Table [dbo].[PriceWay] Script Date: 01/02/2019 08:36:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PriceWay](
[Id] [smallint] NOT NULL,
[Name] [varchar](20) NULL,
CONSTRAINT [PK_PriceWay] PRIMARY KEY NONCLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (1, N'移动平均')
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (2, N'先进先出')
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (3, N'后进先出')
End
--1. 直接指定当前库为 as2018
USE as2018
GO
--2. 判断 as2018 库中是否有 [dbo].[PriceWay] 表,
-- 如果没有才执行添加表和相应数据
IF NOT EXISTS(SELECT 1 FROM sys.tables AS t WHERE t.[object_id]=OBJECT_ID('[dbo].[PriceWay]'))
BEGIN
CREATE TABLE [dbo].[PriceWay](
[Id] [smallint] NOT NULL,
[Name] [varchar](20) NULL,
CONSTRAINT [PK_PriceWay] PRIMARY KEY NONCLUSTERED
(
[Id] ASC
)
) ON [PRIMARY]
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (1, N'移动平均')
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (2, N'先进先出')
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (3, N'后进先出')
END
GO
只要这些,其他的全掉
-- 待操作数据库
DECLARE @dbName nvarchar(20);
SET @dbName='as2018';
-- 当前数据库
DECLARE @curdbName nvarchar(20);
SET @curdbName=(SELECT DB_NAME());
PRINT(@curdbName)
IF @curdbName=@dbName
Begin
PRINT '已选中目标数据库 ' + @dbName;
CREATE TABLE [dbo].[PriceWay](
[Id] [smallint] NOT NULL,
[Name] [varchar](20) NULL,
CONSTRAINT [PK_PriceWay] PRIMARY KEY NONCLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (1, N'移动平均')
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (2, N'先进先出')
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (3, N'后进先出')
End
-- 待操作数据库
DECLARE @dbName nvarchar(20);
SET @dbName='as2018';
-- 当前数据库
DECLARE @curdbName nvarchar(20);
SET @curdbName=(SELECT DB_NAME());
PRINT(@curdbName)
IF @curdbName=@dbName
Begin
PRINT '已选中目标数据库 ' + @dbName;
CREATE TABLE [dbo].[PriceWay](
[Id] [smallint] NOT NULL,
[Name] [varchar](20) NULL,
CONSTRAINT [PK_PriceWay] PRIMARY KEY NONCLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (1, N'移动平均')
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (2, N'先进先出')
INSERT [dbo].[PriceWay] ([Id], [Name]) VALUES (3, N'后进先出')
End