DB_51aspx/JianZhuCaiLiao.sql

(开头部分) 28KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

USE [JianZhuCaiLiao]
GO
/****** Object:  Table [dbo].[pancun]    Script Date: 06/02/2016 09:10:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pancun](
	[Cid] [int] IDENTITY(1000,1) NOT NULL,
	[huoID] [nvarchar](50) NOT NULL,
	[huoName] [char](10) NULL,
	[kucun] [int] NULL,
 CONSTRAINT [PK_pancun_1] PRIMARY KEY CLUSTERED 
(
	[Cid] 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
SET IDENTITY_INSERT [dbo].[pancun] ON
INSERT [dbo].[pancun] ([Cid], [huoID], [huoName], [kucun]) VALUES (1000, N'1000', N'材料1     ', 199)
INSERT [dbo].[pancun] ([Cid], [huoID], [huoName], [kucun]) VALUES (1001, N'1001', N'1         ', 1)
SET IDENTITY_INSERT [dbo].[pancun] OFF
/****** Object:  Table [dbo].[huopin]    Script Date: 06/02/2016 09:10:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[huopin](
	[huoID] [int] IDENTITY(1000,1) NOT NULL,
	[huoName] [char](10) NULL,
	[huoDanwei] [char](10) NULL,
	[splb] [nvarchar](50) NULL,
	[rkdw] [decimal](18, 6) NULL,
	[ckdw] [decimal](18, 6) NULL,
	[yskc] [decimal](18, 0) NULL,
	[bianma] [nvarchar](50) NULL,
	[pancun] [int] NULL,
	[YuJing] [int] NULL,
 CONSTRAINT [PK_huopin] PRIMARY KEY CLUSTERED 
(
	[huoID] 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
SET IDENTITY_INSERT [dbo].[huopin] ON
INSERT [dbo].[huopin] ([huoID], [huoName], [huoDanwei], [splb], [rkdw], [ckdw], [yskc], [bianma], [pancun], [YuJing]) VALUES (1000, N'材料1     ', N'顿        ', N'类别1', CAST(500.000000 AS Decimal(18, 6)), CAST(600.000000 AS Decimal(18, 6)), CAST(0 AS Decimal(18, 0)), N'cl001', 0, 10)
SET IDENTITY_INSERT [dbo].[huopin] OFF
/****** Object:  Table [dbo].[caigou]    Script Date: 06/02/2016 09:10:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
后面还有 321 行代码,购买后查看完整代码

24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用,每次 10 算力,解读结果公开显示在下面。

还没有人解读过这个文件。