Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Sql»ù±¾Óï¾äµÄѧϰ

--²éѯÿ¸öÈ˶©·¹µÄ´ÎÊý
select  username as ÐÕÃû, count(*) as ´ÎÊý from orderitems  group by UserName having count(*)=1
order by ÐÕÃû desc
select distinct username as δע²áÐÕÃû from orderitems
where username not in (select [Name] from Person)
select distinct username as ÒÑ×¢²áÐÕÃû from orderitems where username
in (select [Name] from Person)
--Ë÷ÒýΪ31-40µÄÊý¾Ý
select top 10 * from orderitems where ID not in (select top 30 ID from orderitems)
--¸´ÖÆÊý¾Ý
insert into  distinctselect(UserName,State,OrderTime) select UserName,State,OrderTime from orderitems
--È¥³ýËùÓÐÖØ¸´µÄ¼Ç¼(ÍêÈ«ÖØ¸´)
select distinct UserName ,ID, State,OrderTime into #Table1 from [distinctselect]
delete from [distinctselect]
insert into [distinctselect](UserName,State,OrderTime) select UserName,State,OrderTime from #Table1
drop table #Table1
--ɾ³ýijÁÐÖØ¸´µÄ¼Ç¼
delete   t  
  from   [distinctselect]   t  
  where   exists   (  
  select   1   from   [distinctselect]  where   username=t.username   and   id<t.id) 
select * from [distinctselect] order by username
delete from [distinctselect]


Ïà¹ØÎĵµ£º

SQL Server 2000Êý¾Ý¿âµÄ¶¨Ê±±¸·ÝÉèÖÃ

ÀûÓÃSQL2000µÄ¶¨Ê±±¸·Ý¹¦ÄÜ£¬ÄܺܺöԷþÎñÆ÷ÉϵÄÖØÒªÊý¾ÝÐÅÏ¢½øÐÐÍêÕûµÄ¶¨Ê±±¸·Ý£¬ÒÔ±ãÔÚ·þÎñÆ÷̱»¾»òÊý¾Ý¿â³öÏÖËð»µÊ±¼°Ê±µÄ½øÐлָ´¹¤×÷£¬ÒÔÈ·±£Æ½Ê±µÄ¹¤×÷ÄÜÕý³£µÄ½øÐС£ÏÂÃæÏò´ó¼Ò½éÉÜÒ»ÏÂSQL2000¶¨ÆÚ±¸·ÝµÄÉèÖ÷½·¨£¬¾ßÌåÈçÏ£º
1.         ´ò¿ªSQL2000µÄÆóÒµ¹ÜÀíÆ÷
2.&nbs ......

linq »ñÈ¡Êý¾Ý¿âʱ¼ä »òÕßÖ´ÐÐÆäËû´ø·µ»ØÖµµÄsql²éѯ

 using (LongXingDBDataContext db = new LongXingDBDataContext())
             {
                 DeviceInfo di;
        ......

Sql Server2005 ת Access

ÔÚÍøÉÏÕÒÁËºÃ¶à¹ØÓÚSqlServer2005תaccessµÄ·½·¨£¬´ó¶à¶¼ÊÇÓÃsqlÓï¾ä£¬¶øÎÒ²»ÏëÓÃÄÇÖÖ·½·¨£¬ÓÚÊÇÎÒ×Ô¼ºÃþË÷³öÀ´ÈçºÎ½«SqlServerÊý¾Ý¿âת»»³Éaccess£¬·½·¨¿ÉÄÜÓе㱿£¬²»¹ýÍê³ÉÁËת»»µÄ¹¦ÄÜ¡£ÏÂÃæÊǾßÌå²½Ö裺
1.´ò¿ªAccess£¬½¨Á¢Ò»¸öºó׺ÃûΪ.mdbµÄ¿ÕµÄÊý¾Ý¿âÎļþ£¨Ä¬ÈϺó׺¿ÉÄÜÊÇ.accdb,ÎÒÃǰÑËü¸ÄΪ.mdb¾Í¿ÉÒÔÁË£©£¬È»ºó ......

SQLÓï¾äµ¼Èëµ¼³ö´óÈ«

ÕâÊÇ¡¶VC++¶¯Ì¬Á´½Ó¿â(DLL)±à³ÌÉîÈëdz³ö¡·µÄµÚËIJ¿·Ö£¬ÔĶÁ±¾ÎÄǰ£¬ÇëÏÈÔĶÁǰÈý²¿·Ö£º£¨Ò»£©
¡¢£¨¶þ£©
¡¢£¨Èý£©
¡£
¡¡¡¡MFCÀ©Õ¹DLLµÄÄÚº­ÎªMFCµÄÀ©Õ¹£¬Óû§Ê¹ÓÃMFCÀ©Õ¹DLL¾ÍÏñʹÓÃMFC±¾ÉíµÄDLLÒ»Ñù¡£³ýÁË¿ÉÒÔÔÚMFCÀ©Õ¹DLLµÄÄÚ²¿Ê¹ÓÃMFCÒÔÍ⣬MFCÀ©Õ¹DLLÓëÓ¦ÓóÌÐòµÄ½Ó¿Ú²¿·ÖÒ²¿ÉÒÔÊÇMFC¡£ÎÒÃÇÒ»°ãʹÓÃMFCÀ©Õ¹DLLÀ´°üº¬ ......

SQLʹÓÃÁ´½Ó·þÎñÆ÷Ö´ÐÐÔ¶³ÌÊý¾Ý¿âÉϵĴ洢¹ý³Ì

 
--´´½¨Á´½Ó·þÎñÆ÷
exec sp_addlinkedserver 'server_tmp','','SQLOLEDB','Ô¶³Ì·þÎñÆ÷Ãû»òipµØÖ·'
exec sp_addlinkedsrvlogin 'server_tmp','false',null,'Óû§Ãû','ÃÜÂë'
exec sp_serveroption 'server_lnk','rpc out','true' --Õâ¸öÔÊÐíµ÷ÓÃÁ´½Ó·þÎñÆ÷ÉϵĴ洢¹ý³Ì
go
 
--µ÷Óãº
exec server_tmp.Êý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ