前言:由于更换服务器,所以需要对数据库进行备份,到新服务器还原。
保存脚本法(大数据量时,耗时长,导出的文件大小较大):
打开SQLserver数据管理工具 Microsoft SQL Server Management Studio;
找到要转移的数据库,右键-->任务-->生成脚本;
点击 “下一步”;
完整数据库迁移选第一个,部分迁移(自选)选第二个,点击下一步;
选择“高级”;
按照需要进行选择,默认为只迁移表结构,此次我选“择架构和数据”;
点击“...”选择存放路径及文件名称,默认存到“文档\script.sql”(忘记修改去文档中找),设置好后点击下一步;
此处根据需要选择,一般数据库小的选择第一个,数据库大的选择第二个。否则导出文件过大,恢复数据时比较麻烦。
核对下要迁移的数据是否都包含,包含“下一步”,不包含“上一步”回去添加;
等待进度完成后点击“完成”。
生成脚本动作完成。
1.SQL Server数据库导入脚本文件后,有时候会出现错误,执行前需在数据库最前面添加修改一些代码,.mdf,和.ldf等文件路径和名称要正确
2.有时候需将脚本文件放在C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA才能执行成功
3.执行时直接将导出来的脚本文件拖到数据库目录下执行即可。
数据库最前面需添加修改的sql语句如下:
--指向当前要使用的数据库
use master
go
--判断当前数据库是否存在
if exists (select * from sysdatabases where name='GoogolOrderMangment')
drop database GoogolOrderMangment --删除数据库
go
--创建数据库
create database GoogolOrderMangment
on primary
(
--数据库文件的逻辑名
name='GoogolOrderMangment_data',
--数据库物理文件名(绝对路径)
filename='D:\GoogolOrderMangment_data.mdf',
--数据库文件初始大小
size=10MB,
--数据文件增长量
filegrowth=1MB
)
--创建日志文件
log on
(
name='GoogolOrderMangment_log',
filename='D:\GoogolOrderMangment_log.ldf',
size=2MB,
filegrowth=1MB
)
go
完整代码如下:
--指向当前要使用的数据库
use master
go
--判断当前数据库是否存在
if exists (select * from sysdatabases where name='GoogolOrderMangment')
drop database GoogolOrderMangment --删除数据库
go
--创建数据库
create database GoogolOrderMangment
on primary
(
--数据库文件的逻辑名
name='GoogolOrderMangment_data',
--数据库物理文件名(绝对路径)
filename='D:\GoogolOrderMangment_data.mdf',
--数据库文件初始大小
size=10MB,
--数据文件增长量
filegrowth=1MB
)
--创建日志文件
log on
(
name='GoogolOrderMangment_log',
filename='D:\GoogolOrderMangment_log.ldf',
size=2MB,
filegrowth=1MB
)
go
-----上面的代码需自己添加
USE [GoogolOrderMangment]
GO
/****** Object: Table [dbo].[OrderSchedule] Script Date: 10/08/2018 11:26:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrderSchedule](
[orderId] [int] IDENTITY(1,1) NOT NULL,
[orderstartdate] [date] NOT NULL,
[ordernumber] [nchar](10) NOT NULL,
[orderstatus] [bit] NOT NULL,
[orderfinishdate] [date] NULL,
CONSTRAINT [PK_orderId] PRIMARY KEY CLUSTERED
(
[orderId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [UK_ordernumber] UNIQUE NONCLUSTERED
(
[ordernumber] 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].[OrderSchedule] ON
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5047, CAST(0xB93E0B00 AS Date), N'2018042245', 1, CAST(0xB93E0B00 AS Date))
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5048, CAST(0xD83E0B00 AS Date), N'2018042246', 1, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5049, CAST(0xBA3E0B00 AS Date), N'2018042247', 1, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5050, CAST(0xBA3E0B00 AS Date), N'2018042248', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5051, CAST(0xBA3E0B00 AS Date), N'2018042249', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5052, CAST(0xBA3E0B00 AS Date), N'2018042250', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5053, CAST(0xBA3E0B00 AS Date), N'2018042251', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5054, CAST(0xBA3E0B00 AS Date), N'2018042252', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5055, CAST(0xBA3E0B00 AS Date), N'2018042253', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5056, CAST(0xBA3E0B00 AS Date), N'2018042254', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5057, CAST(0xBA3E0B00 AS Date), N'2018042255', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5058, CAST(0xBA3E0B00 AS Date), N'2018042256', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5059, CAST(0xBA3E0B00 AS Date), N'2018042257', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5060, CAST(0xBA3E0B00 AS Date), N'2018042258', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5061, CAST(0xBA3E0B00 AS Date), N'2018042259', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5062, CAST(0xBA3E0B00 AS Date), N'2018042260', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5063, CAST(0xBA3E0B00 AS Date), N'2018042261', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5064, CAST(0xBA3E0B00 AS Date), N'2018042262', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5065, CAST(0xBA3E0B00 AS Date), N'2018042263', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5066, CAST(0xBA3E0B00 AS Date), N'2018042264', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5067, CAST(0xBA3E0B00 AS Date), N'2018042265', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5068, CAST(0xBA3E0B00 AS Date), N'2018042266', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5069, CAST(0xBA3E0B00 AS Date), N'2018042267', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5070, CAST(0xBA3E0B00 AS Date), N'2018042268', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5071, CAST(0xBA3E0B00 AS Date), N'2018042269', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5072, CAST(0xBA3E0B00 AS Date), N'2018042270', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5073, CAST(0xBA3E0B00 AS Date), N'2018042271', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5074, CAST(0xBA3E0B00 AS Date), N'2018042272', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5075, CAST(0xBA3E0B00 AS Date), N'2018042273', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5076, CAST(0xBA3E0B00 AS Date), N'2018042274', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5077, CAST(0xBA3E0B00 AS Date), N'2018042275', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5078, CAST(0xBA3E0B00 AS Date), N'2018042276', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5079, CAST(0xBA3E0B00 AS Date), N'2018042277', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5080, CAST(0xBA3E0B00 AS Date), N'2018042278', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5081, CAST(0xBA3E0B00 AS Date), N'2018042279', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5082, CAST(0xBA3E0B00 AS Date), N'2018042280', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5083, CAST(0xBA3E0B00 AS Date), N'2018042281', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5084, CAST(0xBA3E0B00 AS Date), N'2018042282', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5085, CAST(0xBA3E0B00 AS Date), N'2018042283', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5086, CAST(0xBA3E0B00 AS Date), N'2018042284', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5087, CAST(0xBA3E0B00 AS Date), N'2018042285', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5088, CAST(0xBA3E0B00 AS Date), N'2018042286', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5089, CAST(0xBA3E0B00 AS Date), N'2018042287', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5090, CAST(0xBA3E0B00 AS Date), N'2018042288', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5091, CAST(0xBA3E0B00 AS Date), N'2018042289', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5092, CAST(0xBA3E0B00 AS Date), N'2018042290', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5093, CAST(0xBA3E0B00 AS Date), N'2018042291', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5094, CAST(0xBA3E0B00 AS Date), N'2018042292', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5095, CAST(0xBA3E0B00 AS Date), N'2018042293', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5096, CAST(0xBA3E0B00 AS Date), N'2018042294', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5097, CAST(0xBA3E0B00 AS Date), N'2018042295', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5098, CAST(0xBA3E0B00 AS Date), N'2018042296', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5099, CAST(0xBA3E0B00 AS Date), N'2018042297', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5100, CAST(0xBA3E0B00 AS Date), N'2018042298', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5101, CAST(0xBA3E0B00 AS Date), N'2018042299', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5102, CAST(0xBA3E0B00 AS Date), N'2018042300', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5103, CAST(0xBA3E0B00 AS Date), N'2018042301', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5104, CAST(0xBA3E0B00 AS Date), N'2018042302', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5105, CAST(0xBA3E0B00 AS Date), N'2018042303', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5106, CAST(0xBA3E0B00 AS Date), N'2018042304', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5107, CAST(0xBA3E0B00 AS Date), N'2018042305', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5108, CAST(0xBA3E0B00 AS Date), N'2018042306', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5109, CAST(0xBA3E0B00 AS Date), N'2018042307', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5110, CAST(0xBA3E0B00 AS Date), N'2018042308', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5111, CAST(0xBA3E0B00 AS Date), N'2018042309', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5112, CAST(0xBA3E0B00 AS Date), N'2018042310', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5113, CAST(0xBA3E0B00 AS Date), N'2018042311', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5114, CAST(0xBA3E0B00 AS Date), N'2018042313', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5115, CAST(0xBA3E0B00 AS Date), N'2018042314', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5116, CAST(0xBA3E0B00 AS Date), N'2018042315', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5117, CAST(0xBA3E0B00 AS Date), N'2018042316', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5118, CAST(0xBA3E0B00 AS Date), N'2018042317', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5119, CAST(0xBA3E0B00 AS Date), N'2018042318', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5120, CAST(0xBA3E0B00 AS Date), N'2018042319', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5121, CAST(0xBA3E0B00 AS Date), N'2018042320', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5122, CAST(0xBA3E0B00 AS Date), N'2018042321', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5123, CAST(0xBA3E0B00 AS Date), N'2018042322', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5124, CAST(0xBA3E0B00 AS Date), N'2018042323', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5125, CAST(0xBA3E0B00 AS Date), N'2018042324', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5126, CAST(0xBA3E0B00 AS Date), N'2018042325', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5127, CAST(0xBA3E0B00 AS Date), N'2018042326', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5128, CAST(0xBA3E0B00 AS Date), N'2018042327', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5129, CAST(0xBA3E0B00 AS Date), N'2018042328', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5130, CAST(0xBA3E0B00 AS Date), N'2018042329', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5131, CAST(0xBA3E0B00 AS Date), N'2018042330', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5132, CAST(0xBA3E0B00 AS Date), N'2018042331', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5133, CAST(0xBA3E0B00 AS Date), N'2018042332', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5134, CAST(0xBA3E0B00 AS Date), N'2018042333', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5135, CAST(0xBA3E0B00 AS Date), N'2018042334', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5136, CAST(0xBA3E0B00 AS Date), N'2018042335', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5137, CAST(0xBA3E0B00 AS Date), N'2018042336', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5138, CAST(0xBA3E0B00 AS Date), N'2018042337', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5139, CAST(0xBA3E0B00 AS Date), N'2018042338', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5140, CAST(0xBA3E0B00 AS Date), N'2018042339', 0, NULL)
INSERT [dbo].[OrderSchedule] ([orderId], [orderstartdate], [ordernumber], [orderstatus], [orderfinishdate]) VALUES (5141, CAST(0xBA3E0B00 AS Date), N'2018042340', 0, NULL)
SET IDENTITY_INSERT [dbo].[OrderSchedule] OFF
/****** Object: Table [dbo].[OrderScan] Script Date: 10/08/2018 11:26:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrderScan](
[ScanID] [int] IDENTITY(1,1) NOT NULL,
[materialscode] [nchar](10) NOT NULL,
[productname] [nvarchar](50) NULL,
[materialsquantity] [int] NOT NULL,
[productbarcode] [nchar](15) NOT NULL,
[actualquantity] [int] NOT NULL,
CONSTRAINT [PK_OrderScan] PRIMARY KEY CLUSTERED
(
[ScanID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [UN_productbarcaode] UNIQUE NONCLUSTERED
(
[productbarcode] 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
/****** Object: Table [dbo].[OrderDetails] Script Date: 10/08/2018 11:26:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrderDetails](
[ID] [int] NOT NULL,
[orderdate] [date] NOT NULL,
[ordernumber] [nchar](10) NOT NULL,
[materialscode] [nchar](10) NOT NULL,
[productname] [nvarchar](50) NULL,
[productmodel] [nvarchar](50) NULL,
[materialsquantity] [int] NOT NULL,
CONSTRAINT [PK_ID] 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
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (1, CAST(0xBA3E0B00 AS Date), N'2018042245', N'31000966 ', N'运动控制器GTS卡', N'GTS-400-PV-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (2, CAST(0xBA3E0B00 AS Date), N'2018042245', N'31000970 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-V-A', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (3, CAST(0xBA3E0B00 AS Date), N'2018042245', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (4, CAST(0xBA3E0B00 AS Date), N'2018042245', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (5, CAST(0xBA3E0B00 AS Date), N'2018042246', N'31000523 ', N'一体化运动控制器', N'GUC-400-TPG-M01-L2-F4G', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (6, CAST(0xBA3E0B00 AS Date), N'2018042246', N'31001045 ', N'运动控制器GTS4轴端子板(标准无logo)', N'GT2-400-ACC2-VB-G(无logo)', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (7, CAST(0xBA3E0B00 AS Date), N'2018042246', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (8, CAST(0xBA3E0B00 AS Date), N'2018042246', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (9, CAST(0xBA3E0B00 AS Date), N'2018042247', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (10, CAST(0xBA3E0B00 AS Date), N'2018042247', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (11, CAST(0xBA3E0B00 AS Date), N'2018042247', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (12, CAST(0xBA3E0B00 AS Date), N'2018042247', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (13, CAST(0xBA3E0B00 AS Date), N'2018042247', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (14, CAST(0xBA3E0B00 AS Date), N'2018042247', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (15, CAST(0xBA3E0B00 AS Date), N'2018042248', N'14901074 ', N'安川驱动器连接线(带抱闸)3M', N'ACC5-D04030(带绝对值功能)1202696LP', 24)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (16, CAST(0xBA3E0B00 AS Date), N'2018042249', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (17, CAST(0xBA3E0B00 AS Date), N'2018042249', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (18, CAST(0xBA3E0B00 AS Date), N'2018042250', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (19, CAST(0xBA3E0B00 AS Date), N'2018042250', N'31000971 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G-A', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (20, CAST(0xBA3E0B00 AS Date), N'2018042250', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (21, CAST(0xBA3E0B00 AS Date), N'2018042250', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (22, CAST(0xBA3E0B00 AS Date), N'2018042250', N'31000975 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G-A', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (23, CAST(0xBA3E0B00 AS Date), N'2018042250', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (24, CAST(0xBA3E0B00 AS Date), N'2018042250', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (25, CAST(0xBA3E0B00 AS Date), N'2018042250', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (26, CAST(0xBA3E0B00 AS Date), N'2018042250', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (27, CAST(0xBA3E0B00 AS Date), N'2018042250', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (28, CAST(0xBA3E0B00 AS Date), N'2018042251', N'14900009 ', N'驱动器连接电缆ACC5-D01020', N'DB25P(M)+HPCN50P(M) 2.0米', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (29, CAST(0xBA3E0B00 AS Date), N'2018042252', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 35)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (30, CAST(0xBA3E0B00 AS Date), N'2018042252', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 35)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (31, CAST(0xBA3E0B00 AS Date), N'2018042253', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 49)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (32, CAST(0xBA3E0B00 AS Date), N'2018042253', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 49)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (33, CAST(0xBA3E0B00 AS Date), N'2018042253', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 49)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (34, CAST(0xBA3E0B00 AS Date), N'2018042253', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 49)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (35, CAST(0xBA3E0B00 AS Date), N'2018042254', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (36, CAST(0xBA3E0B00 AS Date), N'2018042254', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (37, CAST(0xBA3E0B00 AS Date), N'2018042255', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (38, CAST(0xBA3E0B00 AS Date), N'2018042255', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (39, CAST(0xBA3E0B00 AS Date), N'2018042255', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (40, CAST(0xBA3E0B00 AS Date), N'2018042255', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (41, CAST(0xBA3E0B00 AS Date), N'2018042256', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (42, CAST(0xBA3E0B00 AS Date), N'2018042256', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (43, CAST(0xBA3E0B00 AS Date), N'2018042256', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (44, CAST(0xBA3E0B00 AS Date), N'2018042256', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (45, CAST(0xBA3E0B00 AS Date), N'2018042257', N'31000077 ', N'三轴雕刻控制器', N'GE-300-SG-ENG-PCI-G', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (46, CAST(0xBA3E0B00 AS Date), N'2018042257', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (47, CAST(0xBA3E0B00 AS Date), N'2018042258', N'14900567 ', N'台达B2驱动器连接线缆(光耦驱动)1.0m', N'ACC4-D25-010-001', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (48, CAST(0xBA3E0B00 AS Date), N'2018042258', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (49, CAST(0xBA3E0B00 AS Date), N'2018042258', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (50, CAST(0xBA3E0B00 AS Date), N'2018042258', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (51, CAST(0xBA3E0B00 AS Date), N'2018042258', N'36000009 ', N'固高CPAC-GRT实时内核软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (52, CAST(0xBA3E0B00 AS Date), N'2018042259', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (53, CAST(0xBA3E0B00 AS Date), N'2018042259', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (54, CAST(0xBA3E0B00 AS Date), N'2018042259', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (55, CAST(0xBA3E0B00 AS Date), N'2018042259', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (56, CAST(0xBA3E0B00 AS Date), N'2018042259', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (57, CAST(0xBA3E0B00 AS Date), N'2018042259', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (58, CAST(0xBA3E0B00 AS Date), N'2018042259', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (59, CAST(0xBA3E0B00 AS Date), N'2018042259', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (60, CAST(0xBA3E0B00 AS Date), N'2018042259', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (61, CAST(0xBA3E0B00 AS Date), N'2018042260', N'34000039 ', N'伟立手持盒', N'GAR-WL-HANDLE-01A-15M', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (62, CAST(0xBA3E0B00 AS Date), N'2018042261', N'34000035 ', N'伟立手持盒', N'GAR-WL-HANDLE-01A-08M', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (63, CAST(0xBA3E0B00 AS Date), N'2018042262', N'34000035 ', N'伟立手持盒', N'GAR-WL-HANDLE-01A-08M', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (64, CAST(0xBA3E0B00 AS Date), N'2018042263', N'33000031 ', N'gLink200模块', N'HCB3-1616-DTD01', 8)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (65, CAST(0xBA3E0B00 AS Date), N'2018042263', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 8)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (66, CAST(0xBA3E0B00 AS Date), N'2018042264', N'33000031 ', N'gLink200模块', N'HCB3-1616-DTD01', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (67, CAST(0xBA3E0B00 AS Date), N'2018042264', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (68, CAST(0xBA3E0B00 AS Date), N'2018042265', N'31001120 ', N'GUS-CANopen控制器', N'GUS-500-TNC-P02-F4G', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (69, CAST(0xBA3E0B00 AS Date), N'2018042265', N'33000031 ', N'gLink200模块', N'HCB3-1616-DTD01', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (70, CAST(0xBA3E0B00 AS Date), N'2018042265', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (71, CAST(0xBA3E0B00 AS Date), N'2018042266', N'33000031 ', N'gLink200模块', N'HCB3-1616-DTD01', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (72, CAST(0xBA3E0B00 AS Date), N'2018042266', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (73, CAST(0xBA3E0B00 AS Date), N'2018042267', N'31001143 ', N'GUS运动控制器', N'GUS-600-TG03-HD', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (74, CAST(0xBA3E0B00 AS Date), N'2018042268', N'33000034 ', N'gLink200模块', N'HCB3-1616-DTS01', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (75, CAST(0xBA3E0B00 AS Date), N'2018042268', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (76, CAST(0xBA3E0B00 AS Date), N'2018042269', N'34000039 ', N'伟立手持盒', N'GAR-WL-HANDLE-01A-15M', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (77, CAST(0xBA3E0B00 AS Date), N'2018042270', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (78, CAST(0xBA3E0B00 AS Date), N'2018042271', N'36000226 ', N'扫光机控制系统', N'GTC-CNC-S60-P0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (79, CAST(0xBA3E0B00 AS Date), N'2018042271', N'34000042 ', N'CNC继电器板', N'CNC-TER-02A', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (80, CAST(0xBA3E0B00 AS Date), N'2018042271', N'14900738 ', N'继电器板电缆', N'GTC-HDDB15P/M-750MM', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (81, CAST(0xBA3E0B00 AS Date), N'2018042271', N'12800076 ', N'冲PIN-DB头', N'DB25P/M直 焊线', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (82, CAST(0xBA3E0B00 AS Date), N'2018042271', N'12800366 ', N'外壳', N'DB25外壳', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (83, CAST(0xBA3E0B00 AS Date), N'2018042271', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (84, CAST(0xBA3E0B00 AS Date), N'2018042272', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (85, CAST(0xBA3E0B00 AS Date), N'2018042272', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (86, CAST(0xBA3E0B00 AS Date), N'2018042273', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (87, CAST(0xBA3E0B00 AS Date), N'2018042273', N'14900634 ', N'6芯连接电缆', N'DB9P F/M L=5m(PIW-2862C-5M)', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (88, CAST(0xBA3E0B00 AS Date), N'2018042273', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (89, CAST(0xBA3E0B00 AS Date), N'2018042273', N'12800076 ', N'冲PIN-DB头', N'DB25P/M直 焊线', 12)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (90, CAST(0xBA3E0B00 AS Date), N'2018042273', N'12800366 ', N'外壳', N'DB25外壳', 12)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (91, CAST(0xBA3E0B00 AS Date), N'2018042274', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (92, CAST(0xBA3E0B00 AS Date), N'2018042274', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (93, CAST(0xBA3E0B00 AS Date), N'2018042274', N'14900634 ', N'6芯连接电缆', N'DB9P F/M L=5m(PIW-2862C-5M)', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (94, CAST(0xBA3E0B00 AS Date), N'2018042274', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (95, CAST(0xBA3E0B00 AS Date), N'2018042274', N'12800076 ', N'冲PIN-DB头', N'DB25P/M直 焊线', 12)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (96, CAST(0xBA3E0B00 AS Date), N'2018042274', N'12800366 ', N'外壳', N'DB25外壳', 12)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (97, CAST(0xBA3E0B00 AS Date), N'2018042275', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (98, CAST(0xBA3E0B00 AS Date), N'2018042275', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 6)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (99, CAST(0xBA3E0B00 AS Date), N'2018042275', N'14900634 ', N'6芯连接电缆', N'DB9P F/M L=5m(PIW-2862C-5M)', 6)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (100, CAST(0xBA3E0B00 AS Date), N'2018042276', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (101, CAST(0xBA3E0B00 AS Date), N'2018042276', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
GO
print 'Processed 100 total records'
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (102, CAST(0xBA3E0B00 AS Date), N'2018042276', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (103, CAST(0xBA3E0B00 AS Date), N'2018042277', N'31001143 ', N'GUS运动控制器', N'GUS-600-TG03-HD', 15)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (104, CAST(0xBA3E0B00 AS Date), N'2018042278', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (105, CAST(0xBA3E0B00 AS Date), N'2018042278', N'31000970 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-V-A', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (106, CAST(0xBA3E0B00 AS Date), N'2018042278', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (107, CAST(0xBA3E0B00 AS Date), N'2018042278', N'12800076 ', N'冲PIN-DB头', N'DB25P/M直 焊线', 12)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (108, CAST(0xBA3E0B00 AS Date), N'2018042278', N'12800366 ', N'外壳', N'DB25外壳', 12)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (109, CAST(0xBA3E0B00 AS Date), N'2018042278', N'31000966 ', N'运动控制器GTS卡', N'GTS-400-PV-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (110, CAST(0xBA3E0B00 AS Date), N'2018042278', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (111, CAST(0xBA3E0B00 AS Date), N'2018042279', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (112, CAST(0xBA3E0B00 AS Date), N'2018042279', N'31000975 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G-A', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (113, CAST(0xBA3E0B00 AS Date), N'2018042279', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (114, CAST(0xBA3E0B00 AS Date), N'2018042279', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (115, CAST(0xBA3E0B00 AS Date), N'2018042279', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (116, CAST(0xBA3E0B00 AS Date), N'2018042279', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (117, CAST(0xBA3E0B00 AS Date), N'2018042279', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (118, CAST(0xBA3E0B00 AS Date), N'2018042280', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (119, CAST(0xBA3E0B00 AS Date), N'2018042280', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (120, CAST(0xBA3E0B00 AS Date), N'2018042280', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (121, CAST(0xBA3E0B00 AS Date), N'2018042280', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (122, CAST(0xBA3E0B00 AS Date), N'2018042280', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 175)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (123, CAST(0xBA3E0B00 AS Date), N'2018042280', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 175)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (124, CAST(0xBA3E0B00 AS Date), N'2018042281', N'31000986 ', N'运动控制器GTS卡', N'GTS-400-PG-VB-LASER', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (125, CAST(0xBA3E0B00 AS Date), N'2018042281', N'31000971 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G-A', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (126, CAST(0xBA3E0B00 AS Date), N'2018042281', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (127, CAST(0xBA3E0B00 AS Date), N'2018042281', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (128, CAST(0xBA3E0B00 AS Date), N'2018042282', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (129, CAST(0xBA3E0B00 AS Date), N'2018042283', N'33000020 ', N'扩展IO模块', N'ACC-S1616D V1.1(无线缆)', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (130, CAST(0xBA3E0B00 AS Date), N'2018042283', N'14900059 ', N'IO模块连接电缆', N'300-350-ST01', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (131, CAST(0xBA3E0B00 AS Date), N'2018042283', N'12800407 ', N'总线连接器(欧辰)', N'CPAC-300-972-GA1000', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (132, CAST(0xBA3E0B00 AS Date), N'2018042284', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (133, CAST(0xBA3E0B00 AS Date), N'2018042284', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (134, CAST(0xBA3E0B00 AS Date), N'2018042285', N'14900014 ', N'屏蔽电缆ACC3-A1-062030', N'DB62PIN M+F 3.0米', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (135, CAST(0xBA3E0B00 AS Date), N'2018042285', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 18)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (136, CAST(0xBA3E0B00 AS Date), N'2018042285', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 18)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (137, CAST(0xBA3E0B00 AS Date), N'2018042285', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 18)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (138, CAST(0xBA3E0B00 AS Date), N'2018042285', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 18)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (139, CAST(0xBA3E0B00 AS Date), N'2018042285', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 18)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (140, CAST(0xBA3E0B00 AS Date), N'2018042285', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 18)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (141, CAST(0xBA3E0B00 AS Date), N'2018042286', N'31000284 ', N'运控端子板', N'GA1-400-ACC2-G', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (142, CAST(0xBA3E0B00 AS Date), N'2018042286', N'31000283 ', N'运动控制卡', N'GT-X00-SD-PCI', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (143, CAST(0xBA3E0B00 AS Date), N'2018042287', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 120)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (144, CAST(0xBA3E0B00 AS Date), N'2018042287', N'31000655 ', N'运控器主卡', N'GTS-800-PG-G-MB-V1.0', 120)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (145, CAST(0xBA3E0B00 AS Date), N'2018042287', N'31000313 ', N'八轴端子板', N'GT2-800-ACC2-V2.0-G', 120)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (146, CAST(0xBA3E0B00 AS Date), N'2018042287', N'14900451 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN17', 120)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (147, CAST(0xBA3E0B00 AS Date), N'2018042287', N'14900454 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN18', 120)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (148, CAST(0xBA3E0B00 AS Date), N'2018042288', N'31000655 ', N'运控器主卡', N'GTS-800-PG-G-MB-V1.0', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (149, CAST(0xBA3E0B00 AS Date), N'2018042288', N'31000313 ', N'八轴端子板', N'GT2-800-ACC2-V2.0-G', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (150, CAST(0xBA3E0B00 AS Date), N'2018042288', N'14900451 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN17', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (151, CAST(0xBA3E0B00 AS Date), N'2018042288', N'14900454 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN18', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (152, CAST(0xBA3E0B00 AS Date), N'2018042288', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (153, CAST(0xBA3E0B00 AS Date), N'2018042289', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (154, CAST(0xBA3E0B00 AS Date), N'2018042289', N'31000655 ', N'运控器主卡', N'GTS-800-PG-G-MB-V1.0', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (155, CAST(0xBA3E0B00 AS Date), N'2018042289', N'31000313 ', N'八轴端子板', N'GT2-800-ACC2-V2.0-G', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (156, CAST(0xBA3E0B00 AS Date), N'2018042289', N'14900451 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN17', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (157, CAST(0xBA3E0B00 AS Date), N'2018042289', N'14900454 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN18', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (158, CAST(0xBA3E0B00 AS Date), N'2018042290', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (159, CAST(0xBA3E0B00 AS Date), N'2018042290', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (160, CAST(0xBA3E0B00 AS Date), N'2018042290', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (161, CAST(0xBA3E0B00 AS Date), N'2018042290', N'33000041 ', N'glink200模块', N'HCB2-0604-A1201', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (162, CAST(0xBA3E0B00 AS Date), N'2018042290', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (163, CAST(0xBA3E0B00 AS Date), N'2018042290', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (164, CAST(0xBA3E0B00 AS Date), N'2018042291', N'14900451 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (165, CAST(0xBA3E0B00 AS Date), N'2018042291', N'14900454 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN18', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (166, CAST(0xBA3E0B00 AS Date), N'2018042291', N'14900451 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (167, CAST(0xBA3E0B00 AS Date), N'2018042291', N'14900454 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN18', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (168, CAST(0xBA3E0B00 AS Date), N'2018042292', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (169, CAST(0xBA3E0B00 AS Date), N'2018042292', N'31000971 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G-A', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (170, CAST(0xBA3E0B00 AS Date), N'2018042292', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (171, CAST(0xBA3E0B00 AS Date), N'2018042292', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (172, CAST(0xBA3E0B00 AS Date), N'2018042292', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (173, CAST(0xBA3E0B00 AS Date), N'2018042292', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (174, CAST(0xBA3E0B00 AS Date), N'2018042292', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (175, CAST(0xBA3E0B00 AS Date), N'2018042292', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (176, CAST(0xBA3E0B00 AS Date), N'2018042293', N'36000207 ', N'机器人控制器', N'GRCS-3000-CP-0D-04', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (177, CAST(0xBA3E0B00 AS Date), N'2018042293', N'18000505 ', N'直角坐标XYZA(A代表绕Z轴旋转)', N'XYZA', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (178, CAST(0xBA3E0B00 AS Date), N'2018042293', N'35000373 ', N'机器人手持操作示教器', N'GRP2000-II-V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (179, CAST(0xBA3E0B00 AS Date), N'2018042293', N'18000514 ', N'Welding(弧焊模块)', N'WD', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (180, CAST(0xBA3E0B00 AS Date), N'2018042293', N'18000517 ', N'ExtAxes(外部轴)', N'EA', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (181, CAST(0xBA3E0B00 AS Date), N'2018042293', N'12800076 ', N'冲PIN-DB头', N'DB25P/M直 焊线', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (182, CAST(0xBA3E0B00 AS Date), N'2018042293', N'12800366 ', N'外壳', N'DB25外壳', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (183, CAST(0xBA3E0B00 AS Date), N'2018042293', N'18000084 ', N'固高工业机器人控制系统软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (184, CAST(0xBA3E0B00 AS Date), N'2018042294', N'36000009 ', N'固高CPAC-GRT实时内核软件', N'V1.0', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (185, CAST(0xBA3E0B00 AS Date), N'2018042294', N'31001000 ', N'6轴直线型注塑机机械手控制器', N'GTE-R110-C2', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (186, CAST(0xBA3E0B00 AS Date), N'2018042294', N'12800076 ', N'冲PIN-DB头', N'DB25P/M直 焊线', 12)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (187, CAST(0xBA3E0B00 AS Date), N'2018042294', N'12800366 ', N'外壳', N'DB25外壳', 12)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (188, CAST(0xBA3E0B00 AS Date), N'2018042294', N'35000428 ', N'手持示教器', N'GRP3000L-I-V1.0', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (189, CAST(0xBA3E0B00 AS Date), N'2018042295', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 33)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (190, CAST(0xBA3E0B00 AS Date), N'2018042295', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 86)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (191, CAST(0xBA3E0B00 AS Date), N'2018042295', N'36000002 ', N'固高GE连续轨迹运动控制软件V1.0', N'', 53)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (192, CAST(0xBA3E0B00 AS Date), N'2018042295', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 86)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (193, CAST(0xBA3E0B00 AS Date), N'2018042295', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 86)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (194, CAST(0xBA3E0B00 AS Date), N'2018042295', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 53)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (195, CAST(0xBA3E0B00 AS Date), N'2018042295', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 53)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (196, CAST(0xBA3E0B00 AS Date), N'2018042295', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 53)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (197, CAST(0xBA3E0B00 AS Date), N'2018042295', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (198, CAST(0xBA3E0B00 AS Date), N'2018042295', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 30)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (199, CAST(0xBA3E0B00 AS Date), N'2018042295', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 33)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (200, CAST(0xBA3E0B00 AS Date), N'2018042295', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 33)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (201, CAST(0xBA3E0B00 AS Date), N'2018042295', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 119)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (202, CAST(0xBA3E0B00 AS Date), N'2018042295', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 33)
GO
print 'Processed 200 total records'
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (203, CAST(0xBA3E0B00 AS Date), N'2018042296', N'35000479 ', N'机器人示教器', N'GRP3000-I-V1.0(AFT)', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (204, CAST(0xBA3E0B00 AS Date), N'2018042296', N'33000073 ', N'glink200模块', N'HCB5-0604-A1201', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (205, CAST(0xBA3E0B00 AS Date), N'2018042296', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (206, CAST(0xBA3E0B00 AS Date), N'2018042297', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (207, CAST(0xBA3E0B00 AS Date), N'2018042297', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (208, CAST(0xBA3E0B00 AS Date), N'2018042297', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (209, CAST(0xBA3E0B00 AS Date), N'2018042298', N'31000531 ', N'运动控制器', N'GT-400-SCAN-PCI-O(5V,3M)', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (210, CAST(0xBA3E0B00 AS Date), N'2018042299', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (211, CAST(0xBA3E0B00 AS Date), N'2018042299', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (212, CAST(0xBA3E0B00 AS Date), N'2018042299', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (213, CAST(0xBA3E0B00 AS Date), N'2018042300', N'36000189 ', N'拿云6机器人控制器', N'GRCS3000-SD61K006N10I0-06(标准版、IO32/32)', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (214, CAST(0xBA3E0B00 AS Date), N'2018042300', N'18000497 ', N'Articulated_6(标准6R机器人)', N'A6', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (215, CAST(0xBA3E0B00 AS Date), N'2018042300', N'18000513 ', N'Pallet(码垛模块)', N'PL', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (216, CAST(0xBA3E0B00 AS Date), N'2018042300', N'35000117 ', N'机器人示教器', N'GRP3000-I-V1.0(拿云四轴驱控一体机专用)', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (217, CAST(0xBA3E0B00 AS Date), N'2018042300', N'12801389 ', N'重载拖地线缆连接器(标准型)', N'ONK-74100BMC-XLD', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (218, CAST(0xBA3E0B00 AS Date), N'2018042300', N'36000009 ', N'固高CPAC-GRT实时内核软件', N'V1.0', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (219, CAST(0xBA3E0B00 AS Date), N'2018042300', N'18000084 ', N'固高工业机器人控制系统软件', N'V1.0', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (220, CAST(0xBA3E0B00 AS Date), N'2018042301', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (221, CAST(0xBA3E0B00 AS Date), N'2018042301', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (222, CAST(0xBA3E0B00 AS Date), N'2018042301', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (223, CAST(0xBA3E0B00 AS Date), N'2018042301', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (224, CAST(0xBA3E0B00 AS Date), N'2018042302', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 50)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (225, CAST(0xBA3E0B00 AS Date), N'2018042302', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 50)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (226, CAST(0xBA3E0B00 AS Date), N'2018042303', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (227, CAST(0xBA3E0B00 AS Date), N'2018042303', N'31000655 ', N'运控器主卡', N'GTS-800-PG-G-MB-V1.0', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (228, CAST(0xBA3E0B00 AS Date), N'2018042303', N'31000313 ', N'八轴端子板', N'GT2-800-ACC2-V2.0-G', 6)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (229, CAST(0xBA3E0B00 AS Date), N'2018042303', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 7)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (230, CAST(0xBA3E0B00 AS Date), N'2018042303', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (231, CAST(0xBA3E0B00 AS Date), N'2018042304', N'32000099 ', N'固高网络型智能伺服驱动器', N'GTSD13-T4-K011X1-N04X0', 8)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (232, CAST(0xBA3E0B00 AS Date), N'2018042304', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 8)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (233, CAST(0xBA3E0B00 AS Date), N'2018042305', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (234, CAST(0xBA3E0B00 AS Date), N'2018042305', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (235, CAST(0xBA3E0B00 AS Date), N'2018042305', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (236, CAST(0xBA3E0B00 AS Date), N'2018042305', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (237, CAST(0xBA3E0B00 AS Date), N'2018042306', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (238, CAST(0xBA3E0B00 AS Date), N'2018042306', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (239, CAST(0xBA3E0B00 AS Date), N'2018042306', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (240, CAST(0xBA3E0B00 AS Date), N'2018042306', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (241, CAST(0xBA3E0B00 AS Date), N'2018042306', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (242, CAST(0xBA3E0B00 AS Date), N'2018042306', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (243, CAST(0xBA3E0B00 AS Date), N'2018042306', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (244, CAST(0xBA3E0B00 AS Date), N'2018042306', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (245, CAST(0xBA3E0B00 AS Date), N'2018042307', N'31000971 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G-A', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (246, CAST(0xBA3E0B00 AS Date), N'2018042307', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (247, CAST(0xBA3E0B00 AS Date), N'2018042307', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (248, CAST(0xBA3E0B00 AS Date), N'2018042307', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (249, CAST(0xBA3E0B00 AS Date), N'2018042307', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (250, CAST(0xBA3E0B00 AS Date), N'2018042308', N'36000009 ', N'固高CPAC-GRT实时内核软件', N'V1.0', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (251, CAST(0xBA3E0B00 AS Date), N'2018042308', N'18000084 ', N'固高工业机器人控制系统软件', N'V1.0', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (252, CAST(0xBA3E0B00 AS Date), N'2018042308', N'18000497 ', N'Articulated_6(标准6R机器人)', N'A6', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (253, CAST(0xBA3E0B00 AS Date), N'2018042308', N'18000513 ', N'Pallet(码垛模块)', N'PL', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (254, CAST(0xBA3E0B00 AS Date), N'2018042308', N'36000225 ', N'拿云6机器人控制器(AFT)', N'GRCS3000-SD61T3K006E2-N10I0', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (255, CAST(0xBA3E0B00 AS Date), N'2018042308', N'12801389 ', N'重载拖地线缆连接器(标准型)', N'ONK-74100BMC-XLD', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (256, CAST(0xBA3E0B00 AS Date), N'2018042308', N'35000122 ', N'机器人示教器', N'GRP4000-I-VA(驱控一体)', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (257, CAST(0xBA3E0B00 AS Date), N'2018042309', N'31000819 ', N'CPAC-GUS系列控制器', N'通用型 CPAC-OtoBox-UST2-4PG-P01', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (258, CAST(0xBA3E0B00 AS Date), N'2018042309', N'36000009 ', N'固高CPAC-GRT实时内核软件', N'V1.0', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (259, CAST(0xBA3E0B00 AS Date), N'2018042310', N'31000979 ', N'运动控制器GTS卡', N'GTS-400-PV-VB-LASER', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (260, CAST(0xBA3E0B00 AS Date), N'2018042310', N'31000970 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-V-A', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (261, CAST(0xBA3E0B00 AS Date), N'2018042310', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (262, CAST(0xBA3E0B00 AS Date), N'2018042310', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (263, CAST(0xBA3E0B00 AS Date), N'2018042311', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (264, CAST(0xBA3E0B00 AS Date), N'2018042311', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (265, CAST(0xBA3E0B00 AS Date), N'2018042311', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (266, CAST(0xBA3E0B00 AS Date), N'2018042311', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (267, CAST(0xBA3E0B00 AS Date), N'2018042313', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (268, CAST(0xBA3E0B00 AS Date), N'2018042313', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (269, CAST(0xBA3E0B00 AS Date), N'2018042313', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (270, CAST(0xBA3E0B00 AS Date), N'2018042313', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (271, CAST(0xBA3E0B00 AS Date), N'2018042314', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (272, CAST(0xBA3E0B00 AS Date), N'2018042314', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (273, CAST(0xBA3E0B00 AS Date), N'2018042314', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (274, CAST(0xBA3E0B00 AS Date), N'2018042314', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (275, CAST(0xBA3E0B00 AS Date), N'2018042314', N'33000001 ', N'扩展IO模块', N'ACC-S0408A(无线缆)', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (276, CAST(0xBA3E0B00 AS Date), N'2018042314', N'14900059 ', N'IO模块连接电缆', N'300-350-ST01', 6)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (277, CAST(0xBA3E0B00 AS Date), N'2018042314', N'12800407 ', N'总线连接器(欧辰)', N'CPAC-300-972-GA1000', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (278, CAST(0xBA3E0B00 AS Date), N'2018042314', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (279, CAST(0xBA3E0B00 AS Date), N'2018042315', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (280, CAST(0xBA3E0B00 AS Date), N'2018042315', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (281, CAST(0xBA3E0B00 AS Date), N'2018042315', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (282, CAST(0xBA3E0B00 AS Date), N'2018042315', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (283, CAST(0xBA3E0B00 AS Date), N'2018042315', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (284, CAST(0xBA3E0B00 AS Date), N'2018042316', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (285, CAST(0xBA3E0B00 AS Date), N'2018042316', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (286, CAST(0xBA3E0B00 AS Date), N'2018042317', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (287, CAST(0xBA3E0B00 AS Date), N'2018042318', N'31000285 ', N'运动控制卡', N'GE-300/200-SG-PCI', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (288, CAST(0xBA3E0B00 AS Date), N'2018042318', N'31000376 ', N'运控端子板', N'GA1-200-ACC2-R', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (289, CAST(0xBA3E0B00 AS Date), N'2018042318', N'14900010 ', N'屏蔽电缆ACC3-A1-062015', N'DB62PIN M+F 1.5米', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (290, CAST(0xBA3E0B00 AS Date), N'2018042318', N'12800076 ', N'冲PIN-DB头', N'DB25P/M直 焊线', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (291, CAST(0xBA3E0B00 AS Date), N'2018042318', N'12800366 ', N'外壳', N'DB25外壳', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (292, CAST(0xBA3E0B00 AS Date), N'2018042318', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (293, CAST(0xBA3E0B00 AS Date), N'2018042319', N'31000979 ', N'运动控制器GTS卡', N'GTS-400-PV-VB-LASER', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (294, CAST(0xBA3E0B00 AS Date), N'2018042319', N'31000970 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-V-A', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (295, CAST(0xBA3E0B00 AS Date), N'2018042319', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (296, CAST(0xBA3E0B00 AS Date), N'2018042319', N'14900029 ', N'驱动器连接电缆ACC5-D03015', N'安川∑-II系列 YASKAWA SGDM 1.5M(SGDH/SGDM)', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (297, CAST(0xBA3E0B00 AS Date), N'2018042319', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (298, CAST(0xBA3E0B00 AS Date), N'2018042320', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (299, CAST(0xBA3E0B00 AS Date), N'2018042320', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (300, CAST(0xBA3E0B00 AS Date), N'2018042320', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (301, CAST(0xBA3E0B00 AS Date), N'2018042320', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 8)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (302, CAST(0xBA3E0B00 AS Date), N'2018042320', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 8)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (303, CAST(0xBA3E0B00 AS Date), N'2018042320', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 3)
GO
print 'Processed 300 total records'
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (304, CAST(0xBA3E0B00 AS Date), N'2018042321', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (305, CAST(0xBA3E0B00 AS Date), N'2018042321', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (306, CAST(0xBA3E0B00 AS Date), N'2018042321', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (307, CAST(0xBA3E0B00 AS Date), N'2018042321', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (308, CAST(0xBA3E0B00 AS Date), N'2018042321', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (309, CAST(0xBA3E0B00 AS Date), N'2018042321', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (310, CAST(0xBA3E0B00 AS Date), N'2018042321', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (311, CAST(0xBA3E0B00 AS Date), N'2018042321', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (312, CAST(0xBA3E0B00 AS Date), N'2018042322', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 16)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (313, CAST(0xBA3E0B00 AS Date), N'2018042322', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (314, CAST(0xBA3E0B00 AS Date), N'2018042322', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 16)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (315, CAST(0xBA3E0B00 AS Date), N'2018042322', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 16)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (316, CAST(0xBA3E0B00 AS Date), N'2018042322', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 18)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (317, CAST(0xBA3E0B00 AS Date), N'2018042322', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 16)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (318, CAST(0xBA3E0B00 AS Date), N'2018042322', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (319, CAST(0xBA3E0B00 AS Date), N'2018042322', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (320, CAST(0xBA3E0B00 AS Date), N'2018042322', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (321, CAST(0xBA3E0B00 AS Date), N'2018042322', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (322, CAST(0xBA3E0B00 AS Date), N'2018042323', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (323, CAST(0xBA3E0B00 AS Date), N'2018042323', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (324, CAST(0xBA3E0B00 AS Date), N'2018042323', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (325, CAST(0xBA3E0B00 AS Date), N'2018042323', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (326, CAST(0xBA3E0B00 AS Date), N'2018042323', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (327, CAST(0xBA3E0B00 AS Date), N'2018042323', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (328, CAST(0xBA3E0B00 AS Date), N'2018042323', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (329, CAST(0xBA3E0B00 AS Date), N'2018042323', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (330, CAST(0xBA3E0B00 AS Date), N'2018042323', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (331, CAST(0xBA3E0B00 AS Date), N'2018042323', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (332, CAST(0xBA3E0B00 AS Date), N'2018042324', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 38)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (333, CAST(0xBA3E0B00 AS Date), N'2018042324', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 38)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (334, CAST(0xBA3E0B00 AS Date), N'2018042324', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 38)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (335, CAST(0xBA3E0B00 AS Date), N'2018042324', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 38)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (336, CAST(0xBA3E0B00 AS Date), N'2018042324', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 38)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (337, CAST(0xBA3E0B00 AS Date), N'2018042325', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 25)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (338, CAST(0xBA3E0B00 AS Date), N'2018042325', N'14900513 ', N'屏蔽电缆', N'SCSI 68Pin 5.0米 带标识 CN17', 25)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (339, CAST(0xBA3E0B00 AS Date), N'2018042325', N'31001069 ', N'运动控制器GTS主卡', N'GTS-400-PG-VB(SC-000152)', 25)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (340, CAST(0xBA3E0B00 AS Date), N'2018042325', N'31001068 ', N'运控端子板', N'GT2-400-ACC2-VB-G-A(无LOGO)', 25)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (341, CAST(0xBA3E0B00 AS Date), N'2018042326', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (342, CAST(0xBA3E0B00 AS Date), N'2018042326', N'31000971 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G-A', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (343, CAST(0xBA3E0B00 AS Date), N'2018042326', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (344, CAST(0xBA3E0B00 AS Date), N'2018042326', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (345, CAST(0xBA3E0B00 AS Date), N'2018042326', N'14900702 ', N'6芯连接电缆', N'DB9P F M L=3m(PIW-2862C-3M)', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (346, CAST(0xBA3E0B00 AS Date), N'2018042327', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (347, CAST(0xBA3E0B00 AS Date), N'2018042327', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 20)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (348, CAST(0xBA3E0B00 AS Date), N'2018042327', N'14900513 ', N'屏蔽电缆', N'SCSI 68Pin 5.0米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (349, CAST(0xBA3E0B00 AS Date), N'2018042327', N'14900514 ', N'屏蔽电缆', N'SCSI 68Pin 5.0米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (350, CAST(0xBA3E0B00 AS Date), N'2018042328', N'14900009 ', N'驱动器连接电缆ACC5-D01020', N'DB25P(M)+HPCN50P(M) 2.0米', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (351, CAST(0xBA3E0B00 AS Date), N'2018042329', N'31000655 ', N'运控器主卡', N'GTS-800-PG-G-MB-V1.0', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (352, CAST(0xBA3E0B00 AS Date), N'2018042329', N'31000703 ', N'端子板', N'GT2-800-ACC2-V3.0-G', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (353, CAST(0xBA3E0B00 AS Date), N'2018042329', N'14900452 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN17', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (354, CAST(0xBA3E0B00 AS Date), N'2018042329', N'14900455 ', N'屏蔽电缆', N'SCSI 68P 1.5米 带标识 CN18', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (355, CAST(0xBA3E0B00 AS Date), N'2018042329', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (356, CAST(0xBA3E0B00 AS Date), N'2018042330', N'31000966 ', N'运动控制器GTS卡', N'GTS-400-PV-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (357, CAST(0xBA3E0B00 AS Date), N'2018042330', N'31000970 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-V-A', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (358, CAST(0xBA3E0B00 AS Date), N'2018042330', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (359, CAST(0xBA3E0B00 AS Date), N'2018042331', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (360, CAST(0xBA3E0B00 AS Date), N'2018042331', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (361, CAST(0xBA3E0B00 AS Date), N'2018042331', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (362, CAST(0xBA3E0B00 AS Date), N'2018042331', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (363, CAST(0xBA3E0B00 AS Date), N'2018042332', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 15)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (364, CAST(0xBA3E0B00 AS Date), N'2018042332', N'14900408 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN18', 15)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (365, CAST(0xBA3E0B00 AS Date), N'2018042333', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (366, CAST(0xBA3E0B00 AS Date), N'2018042333', N'31000971 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G-A', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (367, CAST(0xBA3E0B00 AS Date), N'2018042333', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (368, CAST(0xBA3E0B00 AS Date), N'2018042333', N'31000965 ', N'运动控制器GTS卡', N'GTS-800-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (369, CAST(0xBA3E0B00 AS Date), N'2018042333', N'31000973 ', N'运动控制器GTS8轴端子板', N'GT2-800-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (370, CAST(0xBA3E0B00 AS Date), N'2018042333', N'14900451 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (371, CAST(0xBA3E0B00 AS Date), N'2018042333', N'14900454 ', N'屏蔽电缆', N'SCSI 68P 1米 带标识 CN18', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (372, CAST(0xBA3E0B00 AS Date), N'2018042333', N'33000029 ', N'Glink200模块', N'HCB2-1616-DTD01', 8)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (373, CAST(0xBA3E0B00 AS Date), N'2018042333', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 8)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (374, CAST(0xBA3E0B00 AS Date), N'2018042333', N'14900139 ', N'驱动器连接电缆ACC5-D01010', N'DB25P(M)+HPCN50P(M) L=1米', 6)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (375, CAST(0xBA3E0B00 AS Date), N'2018042333', N'14900029 ', N'驱动器连接电缆ACC5-D03015', N'安川∑-II系列 YASKAWA SGDM 1.5M(SGDH/SGDM)', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (376, CAST(0xBA3E0B00 AS Date), N'2018042333', N'14900028 ', N'驱动器连接电缆ACC5-D04015', N'安川∑-II系列 YASKAWA SGDM 抱闸出线 1.5M', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (377, CAST(0xBA3E0B00 AS Date), N'2018042333', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (378, CAST(0xBA3E0B00 AS Date), N'2018042333', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (379, CAST(0xBA3E0B00 AS Date), N'2018042334', N'36000002 ', N'固高GE连续轨迹运动控制软件V1.0', N'', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (380, CAST(0xBA3E0B00 AS Date), N'2018042334', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (381, CAST(0xBA3E0B00 AS Date), N'2018042334', N'31000285 ', N'运动控制卡', N'GE-300/200-SG-PCI', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (382, CAST(0xBA3E0B00 AS Date), N'2018042334', N'31000376 ', N'运控端子板', N'GA1-200-ACC2-R', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (383, CAST(0xBA3E0B00 AS Date), N'2018042334', N'14900010 ', N'屏蔽电缆ACC3-A1-062015', N'DB62PIN M+F 1.5米', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (384, CAST(0xBA3E0B00 AS Date), N'2018042334', N'31000288 ', N'运动控制卡', N'GT-200-SG-PCI', 2)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (385, CAST(0xBA3E0B00 AS Date), N'2018042334', N'14900014 ', N'屏蔽电缆ACC3-A1-062030', N'DB62PIN M+F 3.0米', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (386, CAST(0xBA3E0B00 AS Date), N'2018042335', N'31000286 ', N'运控端子板', N'GA1-400-ACC2-R', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (387, CAST(0xBA3E0B00 AS Date), N'2018042335', N'14900014 ', N'屏蔽电缆ACC3-A1-062030', N'DB62PIN M+F 3.0米', 10)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (388, CAST(0xBA3E0B00 AS Date), N'2018042335', N'36000003 ', N'固高GE点位运动控制软件V1.0', N'', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (389, CAST(0xBA3E0B00 AS Date), N'2018042335', N'31000289 ', N'运动控制卡', N'GE-400-SG-PCI', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (390, CAST(0xBA3E0B00 AS Date), N'2018042336', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (391, CAST(0xBA3E0B00 AS Date), N'2018042336', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (392, CAST(0xBA3E0B00 AS Date), N'2018042336', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (393, CAST(0xBA3E0B00 AS Date), N'2018042336', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (394, CAST(0xBA3E0B00 AS Date), N'2018042337', N'31000967 ', N'运动控制器GTS卡', N'GTS-400-PG-VB', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (395, CAST(0xBA3E0B00 AS Date), N'2018042337', N'31000969 ', N'运动控制器GTS4轴端子板', N'GT2-400-ACC2-VB-G', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (396, CAST(0xBA3E0B00 AS Date), N'2018042337', N'14900407 ', N'屏蔽电缆', N'SCSI 68Pin 3米 带标识 CN17', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (397, CAST(0xBA3E0B00 AS Date), N'2018042337', N'36000010 ', N'固高GTS点位运动控制软件', N'V1.0', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (398, CAST(0xBA3E0B00 AS Date), N'2018042338', N'14300067 ', N'人机界面', N'GTC-TP-02A,12寸触摸屏800*600', 3)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (399, CAST(0xBA3E0B00 AS Date), N'2018042339', N'31000775 ', N'自动化控制器', N'CPAC-OtoBox-UCT2H-4PG-M23', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (400, CAST(0xBA3E0B00 AS Date), N'2018042339', N'33000031 ', N'gLink200模块', N'HCB3-1616-DTD01', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (401, CAST(0xBA3E0B00 AS Date), N'2018042339', N'14900527 ', N'6芯连接电缆', N'DB9P F/M L=1.5m (PIW-2862C-1.5M)', 5)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (402, CAST(0xBA3E0B00 AS Date), N'2018042339', N'36000009 ', N'固高CPAC-GRT实时内核软件', N'V1.0', 4)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (403, CAST(0xBA3E0B00 AS Date), N'2018042340', N'31000775 ', N'自动化控制器', N'CPAC-OtoBox-UCT2H-4PG-M23', 1)
INSERT [dbo].[OrderDetails] ([ID], [orderdate], [ordernumber], [materialscode], [productname], [productmodel], [materialsquantity]) VALUES (404, CAST(0xBA3E0B00 AS Date), N'2018042340', N'36000009 ', N'固高CPAC-GRT实时内核软件', N'V1.0', 1)
GO
print 'Processed 400 total records'
/****** Object: Table [dbo].[DupOrderNumber] Script Date: 10/08/2018 11:26:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DupOrderNumber](
[duplicateOrderId] [int] IDENTITY(1,1) NOT NULL,
[dpordernumber] [int] NULL,
CONSTRAINT [PK_DupOrderNumber] PRIMARY KEY CLUSTERED
(
[duplicateOrderId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [UN_DupOrderNumber] UNIQUE NONCLUSTERED
(
[dpordernumber] 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].[DupOrderNumber] ON
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11967, 2018042245)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11968, 2018042246)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11969, 2018042247)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11970, 2018042248)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11971, 2018042249)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11972, 2018042250)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11973, 2018042251)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11974, 2018042252)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11975, 2018042253)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11976, 2018042254)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11977, 2018042255)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11978, 2018042256)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11979, 2018042257)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11980, 2018042258)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11981, 2018042259)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11982, 2018042260)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11983, 2018042261)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11984, 2018042262)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11985, 2018042263)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11986, 2018042264)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11987, 2018042265)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11988, 2018042266)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11989, 2018042267)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11990, 2018042268)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11991, 2018042269)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11992, 2018042270)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11993, 2018042271)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11994, 2018042272)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11995, 2018042273)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11996, 2018042274)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11997, 2018042275)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11998, 2018042276)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (11999, 2018042277)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12000, 2018042278)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12001, 2018042279)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12002, 2018042280)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12003, 2018042281)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12004, 2018042282)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12005, 2018042283)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12006, 2018042284)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12007, 2018042285)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12008, 2018042286)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12009, 2018042287)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12010, 2018042288)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12011, 2018042289)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12012, 2018042290)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12013, 2018042291)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12014, 2018042292)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12015, 2018042293)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12016, 2018042294)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12017, 2018042295)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12018, 2018042296)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12019, 2018042297)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12020, 2018042298)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12021, 2018042299)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12022, 2018042300)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12023, 2018042301)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12024, 2018042302)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12025, 2018042303)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12026, 2018042304)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12027, 2018042305)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12028, 2018042306)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12029, 2018042307)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12030, 2018042308)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12031, 2018042309)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12032, 2018042310)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12033, 2018042311)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12034, 2018042313)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12035, 2018042314)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12036, 2018042315)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12037, 2018042316)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12038, 2018042317)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12039, 2018042318)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12040, 2018042319)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12041, 2018042320)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12042, 2018042321)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12043, 2018042322)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12044, 2018042323)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12045, 2018042324)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12046, 2018042325)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12047, 2018042326)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12048, 2018042327)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12049, 2018042328)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12050, 2018042329)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12051, 2018042330)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12052, 2018042331)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12053, 2018042332)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12054, 2018042333)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12055, 2018042334)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12056, 2018042335)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12057, 2018042336)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12058, 2018042337)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12059, 2018042338)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12060, 2018042339)
INSERT [dbo].[DupOrderNumber] ([duplicateOrderId], [dpordernumber]) VALUES (12061, 2018042340)
SET IDENTITY_INSERT [dbo].[DupOrderNumber] OFF
/****** Object: Table [dbo].[Admins] Script Date: 10/08/2018 11:26:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Admins](
[LoginID] [nchar](10) NOT NULL,
[LoginPwd] [char](10) NOT NULL,
[LoginName] [char](10) NOT NULL,
CONSTRAINT [PK_admin] PRIMARY KEY CLUSTERED
(
[LoginID] 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].[Admins] ([LoginID], [LoginPwd], [LoginName]) VALUES (N'0899 ', N'googoltech', N'左香玲 ')
INSERT [dbo].[Admins] ([LoginID], [LoginPwd], [LoginName]) VALUES (N'1766 ', N'123456 ', N'李访文 ')
/****** Object: Default [DF_orderstatus] Script Date: 10/08/2018 11:26:43 ******/
ALTER TABLE [dbo].[OrderSchedule] ADD CONSTRAINT [DF_orderstatus] DEFAULT ((0)) FOR [orderstatus]
GO
/****** Object: Check [CK_OrderScan] Script Date: 10/08/2018 11:26:43 ******/
ALTER TABLE [dbo].[OrderScan] WITH CHECK ADD CONSTRAINT [CK_OrderScan] CHECK (([actualquantity]>(0)))
GO
ALTER TABLE [dbo].[OrderScan] CHECK CONSTRAINT [CK_OrderScan]
GO
/****** Object: Check [CK_OrderScan_1] Script Date: 10/08/2018 11:26:43 ******/
ALTER TABLE [dbo].[OrderScan] WITH CHECK ADD CONSTRAINT [CK_OrderScan_1] CHECK (([materialsquantity]>(0)))
GO
ALTER TABLE [dbo].[OrderScan] CHECK CONSTRAINT [CK_OrderScan_1]
GO
/****** Object: Check [CK_OrderScan_2] Script Date: 10/08/2018 11:26:43 ******/
ALTER TABLE [dbo].[OrderScan] WITH CHECK ADD CONSTRAINT [CK_OrderScan_2] CHECK (([actualquantity]<=[materialsquantity]))
GO
ALTER TABLE [dbo].[OrderScan] CHECK CONSTRAINT [CK_OrderScan_2]
GO