Êý¾Ý¿âµÄѧϰ£º
1.SELECT * FROM [swcms].[dbo].[t_game] where gameType ='44' and state ='1'
order by dp desc Á½¸öÌõ¼þµþ¼Ó£¬½µÐòÅÅÐò¡£
2.select * from [t_game], [t_game_type_ref] where t_game.Id =t_game_type_ref.gameId Á½¸ö±í¸ñij¸öÊôÐÔÏàͬ£¬²éѯ¡£
3.select * from [swcms].[dbo].[t_game] a,[swcms].[dbo].[t_game_type_ref] b where a.id=b.gameId and gameTypeId ='58'and state ='1' order by dp desc ±í¸ñÈ¡±ðÃû£¬Á½¸ö±í¸ñµÄij¸öÊôÐÔÏàͬ£¬²éѯ¡£
4.SELECT * FROM [swcms].[dbo].[t_game] where pinyin like 's%' and state ='1' order by dp desc Ê××Öĸȷ¶¨£¬ÆäËû×Öĸ²»È·¶¨ µÄÇé¿öϵIJéѯ¡£
5.update t_game_recommend_ref set commendid='2' where commendid='5' ÐÞ¸ÄÊý¾Ý¿âÀïµÄÖµ
6.delete from t_game_type where id ='92'ɾ³ý±í¸ñÖÐidΪ92µÄ¼Ç¼
6.insert into [t_game_type] (id,name,gametypeindex,gamecategory,categoryindex)
VALUES(111,23232323,11111,2,111111);±íÃû£¬ÊôÐÔ£¬Ã¿¸öÊôÐÔÉ趨µÄÖµ¡£
7.SET IDENTITY_INSERT t_game_type ON
insert into t_game_type (id ,name,gameTypeIndex ,gameCategory ,categoryIndex )
values (92,'music',34,3,334)£»ÏÈÒªÉ趨ΪֵÊÇ¿ÉÒÔ¸ü¸ÄµÄ¡£