/*==============================================================*/
/* Database name: pass */
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2005-10-29 22:25:52 */
/* Build by: nostalgic */
/*==============================================================*/


create database pass

go

/*==============================================================*/
/* Table: TestTable */
/*==============================================================*/
create table TestTable(
A int,
B varchar(20))
go
/*==============================================================*/
/* initializeDB */
/*==============================================================*/

insert into TestTable values (10,'数据库应用')
go

insert into TestTable values (11,'数据库应用')
go

insert into TestTable values (11,'数据库应用1')
go

insert into TestTable values (11,'数据库应用2')
go

select *from testTable
go

select count(*) count from TestTable
go

select *from TestTable where A=10
go

select A,count(A) count
from TestTable
group by A
go

delete from testTable
go

drop table TestTable
go