数据库创建(SQL语句)--DropdownList&ListBox连动菜单
来源:互联网 发布:js老虎机效果 编辑:程序博客网 时间:2024/05/29 10:06
- create database Department
- go
- use Department
- go
- create table TDepartment
- (
- depID int primary key,
- depName varchar(30) not null
- )
- go
- insert into TDepartment values(1,'教务')
- insert into TDepartment values(2,'考务')
- insert into TDepartment values(3,'体育')
- insert into TDepartment values(4,'艺术')
- insert into TDepartment values(5,'财务')
- go
- select * from TDepartment
- go
- create table Emp
- (empID int primary key,
- empName varchar(30) not null,
- depID int foreign key references TDepartment(depID)
- )
- go
- insert into Emp values(1,'John',1)
- insert into Emp values(2,'Smith',1)
- insert into Emp values(3,'Green',2)
- insert into Emp values(4,'Joe',2)
- insert into Emp values(5,'Li',3)
- insert into Emp values(6,'Zhang',3)
- insert into Emp values(7,'Chen',4)
- insert into Emp values(8,'Wang',4)
- insert into Emp values(9,'Liu',5)
- insert into Emp values(10,'Xia',5)
- go
- select *from Emp
- go
- 数据库创建(SQL语句)--DropdownList&ListBox连动菜单
- ASP.NET学习笔记--DropdownList&ListBox连动菜单
- sql语句之IN&&EXISTS
- AMP
- AMP
- amp
- sqlserver&&mysql分页sql语句总结
- DropDownList连动菜单
- 关系数据库&&NoSQL数据库
- 备份,还原,压缩数据库 SQL & Access
- Spring.Net&NHibernate 学习
- TweenLite&&TweenMax系列(一)
- sockaddr && sockaddr_in
- awk&&sed脚本语言
- 重新开张 && two pieces of fascinating code
- CsvWriter&&CsvReader
- exit & $?问题
- lex & yacc
- 佛说圣佛母般若波罗蜜多经
- 软件助力IBM绿色创新
- ORACEL数据联动
- MultiByteToWideChar和WideCharToMultiByte用法详解
- 我的开发履历:FAST-REPORT 报表工具接口封装.2006.8
- 数据库创建(SQL语句)--DropdownList&ListBox连动菜单
- usaco 4.1 Cryptcowgraphy 剪枝
- UTF-8与GB2312之间的互换
- connect by prior start with语句详解
- 通过GetPixel()函数获取鼠标点击处的象素颜色判断该点是否在曲线上
- DSP C语言基础要点
- 8位一组压缩字符串
- 视频网站的视频文件下载软件设计和实现(一)
- 在Windows XP下安装Windows Sidebar(侧边栏)-- 中文版