本人对数据库不太了解,想实现表一,表二的内容,全部插入表三.
表一:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_1]
GOCREATE TABLE [dbo].[class_1] (
[sortid] [int] IDENTITY (1, 1) NOT NULL ,
[sort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
表二:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_2]
GOCREATE TABLE [dbo].[class_2] (
[typeid] [int] IDENTITY (1, 1) NOT NULL ,
[typename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sortid] [int] NULL
) ON [PRIMARY]
GO
表三:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_data]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_data]
GOCREATE TABLE [dbo].[class_data] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[sortid] [int] NULL ,
[typeid] [int] NULL ,
[wenti] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[wentilist] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[prio] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ipaddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[haoma] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sysdate] [datetime] NULL ,
[chuli] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
表一:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_1]
GOCREATE TABLE [dbo].[class_1] (
[sortid] [int] IDENTITY (1, 1) NOT NULL ,
[sort] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
表二:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_2]
GOCREATE TABLE [dbo].[class_2] (
[typeid] [int] IDENTITY (1, 1) NOT NULL ,
[typename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sortid] [int] NULL
) ON [PRIMARY]
GO
表三:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[class_data]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[class_data]
GOCREATE TABLE [dbo].[class_data] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[sortid] [int] NULL ,
[typeid] [int] NULL ,
[wenti] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[wentilist] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[prio] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ipaddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[haoma] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[sysdate] [datetime] NULL ,
[chuli] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
解决方案 »
- 自动采集的文章管理系统才完工,做了一个网站测试,请大家拍砖
- ++++这个问题很难,如何远程管理自己的Sqlserer数据库及相关数据表???
- 我應聘遇到的試題:
- 请教发布时语言的问题
- ReturnUrl=%2fFJMS%2fHoutai%2fHelperScripts%2fHYDT.aspx 为什么/全都变成%2f 为什么呀 为什么呀
- 小菜一碟——一步一步用c#写论坛,V1.2源代码发布!
- asp.net 如何实现视频
- 有没有人想过在web 上这样做报表?
- ASP.NET站点的ASPX页面在首次运行时需要编译,速度较慢,有没有什么工具可以对其进行全部主动编译?
- 送分题:关于文件的操作!
- ibatis.net写的asp.net程序如何用nunit测试?
- 请教一个按钮事件的问题
表二:用户名
实现下拉菜单二级联动表三:想把表一,表二的部门及用户名及其它一些其它的数据一同插入到表三,为了以后方便查询请问表三应该怎么设置?我按以下设置无法把表一,表二的数据每次插入过去.