go
	--插入主贴表tid
		insert into bbsTopic(tUID,tSID,tTitle,tMsg,tTime,tCount)
		values (2,4,'范跑跑','谁是范跑跑','2008-7-8',4),
		(3,1,'软件开发','与JAVA的区别是什么呀？','2008-9-1',1),
		(1,3,'今年夏天最流行什么 ','有谁知道今年夏天最流行什么呀？','2008-9-10',2),
		(6,3,'生活中要怎么快乐呀!','平时生活该怎么去快乐呀','2011-11-11',1)
go
	--插入回帖表rid
		insert into bbsReply(rUID,rtime,rtid,rMsg)
		values(1,'2008-7-12',1,'不清楚啊'),
		(4,'2008-11-3',1,'不知道啊'),
		(6,'2009-7-6',1,'就一流氓'),
		(5,'2009-9-5',1,' 好像是个老师吧'),
		(1,'2008-9-2',2,'java比.net、php更加稳定'),
		(2,'2008-9-15',3,'游泳'),
		(3,'2008-9-21',3,'去旅游'),
		(5,'2010-12-13',4,'去旅游')
go
-----------------------------------------------------------
------------------查询语句---------------------------------
	select tsid 板块, count(tsid) 发帖次数 from bbstopic group by tsid
go
	select rtid 主贴,count(rtid) 回帖总数 from bbsreply group by rtid
go
	select tuid 用户,count(tsid) 贴数 from bbstopic group by tuid
go
	select sum(tCount) 回帖总和 from bbstopic
go
	select tid 主贴,tcount 回复数 from bbstopic where tcount>3
go
	select top 1 uName,uSex,uAge,uPoint from bbsUsers order by uPoint desc
go
	select * from bbstopic where tTitle like '%快乐%' or tMsg like '%快乐%'
go
	select * from bbsUsers where uAge between 15 and 20 and upoint>10
go
	select * from bbsUsers where uName like '小_大%'
go
	select tTitle as 标题,tMsg 内容,tTime from bbsTopic where tTime>'2008-6-10 12:00:00' and tcount>1
go
	select * from bbsTopic where tTitle like '%!'