QQ菜单1

INSERT INTO Relation(QQID,RelationQQID,RelationStatus) VALUES (54789625,88662753,0)  INSERT INTO Relation(QQID,RelationQQID,RelationStatus) VALUES (88662753,8855678,1)  INSERT INTO Relation(QQID,RelationQQID,RelationStatus) VALUES (54789625,8855678,0)    SELECT COUNT(*) as 总人数,r.QQID as qq号码  FROM Relation as r  INNER JOIN BaseInfo as b ON (r.RelationQQID = b.QQID)   GROUP BY r.QQID  HAVING COUNT(*)>20  SELECT top 20 COUNT(*) as 总人数,QQID as qq号码  FROM RelationWHERE RelationStatus   GROUP BY QQID  INSERT INTO BaseInfo(QQID,NickName,Sex,Age,Province,City,Address,Phone) VALUES (54789625,'蝴蝶飞飞',1,16,'北京市','北京','亚运村','37547388157668')  INSERT INTO BaseInfo(QQID,NickName,Sex,Age,Province,City,Address,Phone) VALUES (88662753,'秋芙蓉',0,20,'河南省','南阳','方城博望','88715783657725')  INSERT INTO BaseInfo(QQID,NickName,Sex,Age,Province,City,Address,Phone) VALUES (8855678,'双眼皮&猪',1,38,'北京市','北京','双榆树东里','65794968876143')    SELECT r.RelationQQID AS 好友QQ号,NickName as 昵称,Age as 年龄  FROM BaseInfo as b   RIGHT OUTER JOIN Relation AS r ON (r.RelationQQID = b.QQID) WHERE r.RelationStatus = 0    SELECT b.QQID as QQ号码,b.NickName as 昵称,b.Sex as 性别,b.Age as 年龄,b.Province as 省份,b.City as 城市 FROM BaseInfo as b   INNER JOIN QQUser as u ON (u.QQID=b.QQID)  WHERE Province = '北京市' AND  b.Age>=18 and b.Age<=45 AND u.Online = 0    SELECT * FROM BaseInfo WHERE NickName='双眼皮&猪'    SELECT COUNT(*) as 总人数,b.Province as 省份 FROM BaseInfo AS b  INNER JOIN   Relation AS r ON (r.RelationQQID = b.QQID) WHERE r.RelationStatus = 0 and b.QQID=54789625   GROUP BY Province   ORDER BY COUNT(*)    SELECT * FROM BaseInfo as b  INNER JOIN Relation AS r ON (r.RelationQQID = b.QQID)  INNER JOIN QQUser as u ON (u.QQID=b.QQID)   WHERE r.QQID = 54789625 AND r.RelationStatus=0 AND u.Level >= 1      SELECT * FROM BaseInfo as b  INNER JOIN Relation AS r ON (r.RelationQQID = b.QQID)  INNER JOIN QQUser as u ON (u.QQID=b.QQID)    WHERE u.Online=1 AND r.RelationStatus = 0  UPDATE BaseInfo SET NickName='被淹死的鱼',Address = '解放路6号院106室' WHERE QQID=8855678 INSERT INTO QQUser(QQID,PassWord,[LastLogTime],Online,Level) VALUES (54789625,'add512#&','2013-02-16 17:01:35',2,1)   INSERT INTO QQUser(QQID,PassWord,[LastLogTime],Online,Level) VALUES (88662753,'admin0219','2013-02-19 21:08:50',0,5)  INSERT INTO QQUser(QQID,PassWord,[LastLogTime],Online,Level) VALUES (8855678,'guest0221','2013-02-21 16:28:20',1,6)  select * FROM QQUser WHERE Online = 0    SELECT u.QQID AS QQ号码,u.LastLogTime as 最后一次登录时间,u.Level as 等级,b.NickName as 昵称,b.Age as 年龄 FROM QQUser as u  INNER JOIN BaseInfo AS b ON (b.QQID=u.QQID)   WHERE DATEDIFF(dd,u.LastLogTime,GETDATE())>150   ORDER BY u.LastLogTime    UPDATE QQUser SET Online = 0 WHERE QQID=8855678  UPDATE QQUser SET Level+=1 WHERE Level<6  UPDATE QQUser SET Level=-1 WHERE DATEDIFF(dd,LastLogTime,GETDATE())>365