没有合适的资源?快使用搜索试试~ 我知道了~
生成城市sqlserver数据库表便于城市下拉框效果
资源推荐
资源详情
资源评论
USE [ilm]
GO
/****** Object: Table [dbo].[agentCompany_base] Script Date: 10/23/2015 08:42:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agentCompany_base](
[Record_Id] [bigint] IDENTITY(1,1) NOT NULL,
[companyType] [varchar](5) NOT NULL,
[companyCode] [varchar](20) NOT NULL,
[companyName] [varchar](60) NULL,
[shortName] [char](20) NULL,
[tel] [varchar](40) NULL,
[fax] [varchar](40) NULL,
[email] [varchar](60) NULL,
[adderss] [varchar](255) NULL,
[InUserCode] [varchar](20) NULL,
[InDate] [datetime] NULL,
[LastUpUserCode] [varchar](20) NULL,
[LastUp_date] [datetime] NULL,
CONSTRAINT [PK_agentCompany_base] PRIMARY KEY CLUSTERED
(
[Record_Id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[agentCompany_base] Script Date: 10/23/2015 08:42:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[agentCompany_base](
[Record_Id] [bigint] IDENTITY(1,1) NOT NULL,
[companyType] [varchar](5) NOT NULL,
[companyCode] [varchar](20) NOT NULL,
[companyName] [varchar](60) NULL,
[shortName] [char](20) NULL,
[tel] [varchar](40) NULL,
[fax] [varchar](40) NULL,
[email] [varchar](60) NULL,
[adderss] [varchar](255) NULL,
[InUserCode] [varchar](20) NULL,
[InDate] [datetime] NULL,
[LastUpUserCode] [varchar](20) NULL,
[LastUp_date] [datetime] NULL,
CONSTRAINT [PK_agentCompany_base] PRIMARY KEY CLUSTERED
(
[Record_Id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[StoreIn] Script Date: 10/23/2015 08:42:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StoreIn](
[Record_id] [int] IDENTITY(1,1) NOT NULL,
[idGoods] [bigint] NULL,
[idSaleContract] [bigint] NULL,
[goodsNum] [numeric](18, 0) NULL,
CONSTRAINT [PK_StoreIn] PRIMARY KEY CLUSTERED
(
[Record_id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[currencyType] Script Date: 10/23/2015 08:42:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[currencyType](
[id] [int] IDENTITY(1,1) NOT NULL,
[currency] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[StoreIn] Script Date: 10/23/2015 08:42:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StoreIn](
[Record_id] [int] IDENTITY(1,1) NOT NULL,
[idGoods] [bigint] NULL,
[idSaleContract] [bigint] NULL,
[goodsNum] [numeric](18, 0) NULL,
CONSTRAINT [PK_StoreIn] PRIMARY KEY CLUSTERED
(
[Record_id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[currencyType] Script Date: 10/23/2015 08:42:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[currencyType](
[id] [int] IDENTITY(1,1) NOT NULL,
[currency] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
剩余148页未读,继续阅读
资源评论
JohsonMax
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功