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 算力,解读结果公开显示在下面。
还没有人解读过这个文件。