SQLsercer新增

SQLsercer新增

@SQLsercer新增

SQLsercer新增

USE [cdy.business]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dt_db2db_conf](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[dataName] nvarchar NULL,
[sourceId] [int] NULL,
[targetId] [int] NULL,
[isAuto] [int] NULL,
ConSTRAINT [PK_dt_db2db_conf] PRIMARY KEY CLUSTERED
(
[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 IDENTITY_INSERT [dbo].[dt_db2db_conf] ON
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (1, N’黑水水位’, 120183, 110001001, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (2, N’黑水雨量’, 120184, 110401013, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (3, N’黑水流量’, 120185, 110201001, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (4, N’晴朗水位’, 120283, 110201005, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (5, N’晴朗雨量’, 120284, 110401014, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (6, N’晴朗流量’, 120285, 110201007, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (7, N’沙坝水位’, 120483, 110001004, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (8, N’沙坝雨量’, 120484, 110401015, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (9, N’沙坝流量’, 120485, 110201004, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (10, N’三打古雨量’, 120584, 110401005, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (11, N’二木林雨量’, 120684, 110401010, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (12, N’赤不苏水位’, 120783, 110001003, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (13, N’赤不苏雨量’, 120784, 110401016, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (14, N’赤不苏流量’, 120785, 110201003, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (15, N’雪洛雨量’, 120884, 110401006, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (16, N’毛儿盖雨量’, 120984, 110400000, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (17, N’额则雨量’, 121084, 110401008, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (18, N’甘石坝雨量’, 121184, 110401009, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (19, N’才盖雨量’, 121284, 110401011, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (20, N’中村河坝雨量’, 121384, 110401012, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (21, N’毛尔盖坝上备用’, 121481, 110000002, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (22, N’毛儿盖坝上低水位’, 121482, 110000003, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (23, N’毛儿盖坝上高水位’, 121483, 110000004, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (24, N’毛尔盖尾水水位’, 121583, 110000005, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (25, N’知木林水位’, 121683, 110201006, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (26, N’知木林雨量’, 121684, 110401017, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (27, N’知木林流量’, 121685, 110201008, 1);
INSERT [dbo].[dt_db2db_conf] ([id], [dataName], [sourceId], [targetId], [isAuto]) VALUES (28, N’毛尔盖入库流量’, 121785, 110200001, 1);
SET IDENTITY_INSERT [dbo].[dt_db2db_conf] OFF