DB_51aspx/SQLQuery1.sql

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

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [db_EquipmentMS_Data]
GO
/****** Object:  Table [dbo].[tb_zcMain]    Script Date: 04/30/2016 00:56:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_zcMain](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[bh] [varchar](50) NULL,
	[mc] [varchar](50) NULL,
	[xh] [varchar](50) NULL,
	[zclb] [varchar](50) NULL,
	[gbbh] [varchar](50) NULL,
	[xxpz] [varchar](200) NULL,
	[sccj] [varchar](50) NULL,
	[ccrq] [datetime] NULL,
	[zjfs] [varchar](50) NULL,
	[sybm] [varchar](50) NULL,
	[syqk] [varchar](50) NULL,
	[cfdd] [varchar](50) NULL,
	[bgry] [varchar](50) NULL,
	[rzrq] [datetime] NULL,
	[sl] [int] NULL,
	[dw] [varchar](20) NULL,
	[dj] [float] NULL,
	[zcyz] [float] NULL,
	[ljzj] [float] NULL,
	[zcjz] [float] NULL,
	[jczl] [float] NULL,
	[zjff] [varchar](20) NULL,
	[nx] [int] NULL,
	[djrq] [datetime] NULL,
	[djr] [varchar](20) NULL,
	[tm] [varchar](50) NULL,
	[xlh] [varchar](50) NULL,
	[Brand] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[tb_zcMain] ON
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (54, N'MRZC1001-1053', N'办公桌', N'往往外 ', N'办公用品', N'往往外', N'adeaaes 45821', N'往往', CAST(0x0000987100B7B6DC AS DateTime), N'自建', N'办公室', N'使用中', N'仓库', N'李*力', CAST(0x0000987100B7B6DC AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'不计提折旧', 1, CAST(0x0000987100B7B6DC AS DateTime), N'往往外', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (26, N'MRZC1001-1017', N'电话机', N'5685', N'办公用品', N'4521', N'CC12365', N'明日科技', CAST(0x00009796011AD1F4 AS DateTime), N'抵债', N'市场部', N'使用中', N'办公室', N'刘*庆', CAST(0x00009592011AD1F4 AS DateTime), 1, N'台', 1000, 1000, 0, 1000, 10, N'年限平均法（直线法）', 10, CAST(0x0000986C011AD1F4 AS DateTime), N'张*庭', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (27, N'MRZC1001-1026', N'电脑', N'P4 2.0', N'办公用品', N'ZM', N'DDR 512 MIC 5687 CPU P4 3.2', N'明日科技', CAST(0x0000973C01190D9C AS DateTime), N'购入', N'财务部', N'使用中', N'仓库', N'刘*庆', CAST(0x0000942501190D9C AS DateTime), 1, N'台', 3000, 0, 100, 2900, 10, N'年限平均法（直线法）', 10, CAST(0x0000986C01190D9C AS DateTime), N'000', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (28, N'MRZC1001-1027', N'办公桌', N'', N'电脑网络', N'', N'', N'', CAST(0x0000D01400D953F0 AS DateTime), N'购入', N'办公室', N'使用中', N'仓库', N'张*逢', CAST(0x0000D01400D953F0 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D953F0 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (55, N'MRZC1001-54', N'办公桌', N'', N'办公用品', N'', N'', N'', CAST(0x0000987100BA471C AS DateTime), N'购入', N'办公室', N'使用中', N'仓库', N'刘*庆', CAST(0x0000987100BA471C AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000987100BA471C AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (31, N'MRZC1001-1030', N'轿车', N'', N'交通工具', N'', N'', N'', CAST(0x0000D01400D966B0 AS DateTime), N'并购', N'办公室', N'使用中', N'仓库', N'张*逢', CAST(0x0000D01400D966B0 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D967DC AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (32, N'MRZC1001-1031', N'空调', N'', N'通讯工具', N'', N'', N'', CAST(0x0000D01400D96B60 AS DateTime), N'购入', N'办公室', N'使用中', N'仓库', N'刘*庆', CAST(0x0000D01400D96B60 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D96B60 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (33, N'MRZC1001-1032', N'电话机', N'', N'通讯工具', N'', N'', N'', CAST(0x0000D01400D97010 AS DateTime), N'并购', N'办公室', N'使用中', N'1002室', N'张*逢', CAST(0x0000D01400D97010 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D97010 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (34, N'MRZC1001-1033', N'名牌', N'', N'仪器仪表', N'', N'', N'', CAST(0x0000D01400D97718 AS DateTime), N'购入', N'办公室', N'使用中', N'1002室', N'李*力', CAST(0x0000D01400D97718 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D97718 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (35, N'MRZC1001-1034', N'电话机', N'', N'交通工具', N'', N'', N'', CAST(0x0000D01400D97BC8 AS DateTime), N'接受捐赠', N'办公室', N'使用中', N'仓库', N'刘*庆', CAST(0x0000D01400D97BC8 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D97BC8 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (36, N'MRZC1001-1035', N'办公桌', N'', N'电脑网络', N'', N'', N'', CAST(0x0000D01400D99DC4 AS DateTime), N'盘嬴', N'人事部', N'使用中', N'会议室', N'刘*庆', CAST(0x0000D01400D99DC4 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D99DC4 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (37, N'MRZC1001-1036', N'电话机', N'', N'交通工具', N'', N'', N'', CAST(0x0000D01400D9A4CC AS DateTime), N'借用', N'办公室', N'使用中', N'仓库', N'刘*庆', CAST(0x0000D01400D9A4CC AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D9A4CC AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (38, N'MRZC1001-1037', N'办公桌', N'', N'仪器仪表', N'', N'', N'', CAST(0x0000D01400D9AAA8 AS DateTime), N'购入', N'办公室', N'使用中', N'仓库', N'张*逢', CAST(0x0000D01400D9AAA8 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D9AAA8 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (39, N'MRZC1001-1038', N'办公桌', N'', N'通讯工具', N'', N'', N'', CAST(0x0000D01400D9AF58 AS DateTime), N'购入', N'办公室', N'使用中', N'仓库', N'刘*庆', CAST(0x0000D01400D9AF58 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D9AF58 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (40, N'MRZC1001-1039', N'名牌', N'', N'电脑网络', N'', N'', N'', CAST(0x0000D01400D9B534 AS DateTime), N'购入', N'办公室', N'使用中', N'仓库', N'刘*庆', CAST(0x0000D01400D9B534 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'年限平均法（直线法）', 1, CAST(0x0000D01400D9B660 AS DateTime), N'', NULL, NULL, NULL)
INSERT [dbo].[tb_zcMain] ([ID], [bh], [mc], [xh], [zclb], [gbbh], [xxpz], [sccj], [ccrq], [zjfs], [sybm], [syqk], [cfdd], [bgry], [rzrq], [sl], [dw], [dj], [zcyz], [ljzj], [zcjz], [jczl], [zjff], [nx], [djrq], [djr], [tm], [xlh], [Brand]) VALUES (41, N'MRZC1001-1040', N'办公桌', N'', N'办公用品', N'', N'', N'', CAST(0x0000D01400D9B9E4 AS DateTime), N'接受投资', N'办公室', N'使用中', N'仓库', N'张*逢', CAST(0x0000D01400D9B9E4 AS DateTime), 1, N'台', 0, 0, 0, 0, 0, N'不计提折旧', 1, CAST(0x0000D01400D9B9E4 AS DateTime), N'', NULL, NULL, NULL)