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

linq to sql ²åÈëÖµ£¬ÒÔ¼°ÈçºÎÈ¡»Ø×ÔÔöµÄID

linq to sql ÔÚ²åÈëÖµµÄʱºò»¹ÊǺܷ½±ã¡£ÓÐʱºòÎÒÃÇÐèÒªÔÚ²åÈëÒ»¸öеÄʵÌåÖ®ºóµÃµ½ÄǸöʵÌåµÄÖ÷¼üIDµÄÖµ£¬Õâ¸öIDµ±È»±ØÐëÊÇ×ÔÔö¡£Ò»¶Îʱ¼äÎÒÒ»Ö±ÈÏΪֱ½ÓʹÓÃlinq to sqlµÄ²åÈë»úÖÆÊDz»¿ÉÒÔÔÚ×öµ½µÄ£¬ËùÒÔÖ»ÓÐʹÓô洢¹ý³ÌµÄ£¬¾ßÌå¿ÉÒԲ鿴ÕâÆªÎÄÕ£ºhttp://blog.benhall.me.uk/2008/01/custom-insert-logic-with-linq-to-sql.html£¬µ«ÊÇ×ÜÊǾõµÃÕâÑùÌ«Âé·³ÁË¡£Í¨¹ý¹Û²ìlinq to sql²åÈëÖ®ºó²úÉúµÄsql·¢ÏÖ£¬Ëü×Ô¶¯Éú³ÉÁËÁ½ÌõÓï¾ä£¬Ò»Ìõinsert£¬Ò»Ìõselect£¬¶øÇÒÄÇÌõselectÕýºÃ¾ÍÊDzéѯµÄ×îºóÉú³ÉµÄÖ÷¼üID£¬ÕæÊDz»¿É˼Òéѽ¡£¡£
ÏÂÃæÒÔÒ»¸öʵ¼ÊµÄ´úÂëÑÝʾһÏ£º
1.н¨Ò»¸öÐÂÎÅ±í£º
ÁÐÃû             Êý¾ÝÀàÐÍ                        ÔÊÐíΪNULL         ĬÈÏÖµ             Ö÷¼ü
----------------------------------------------------------------------------
ID                 int                                                       ×ÔÔö                ÊÇ
Title              nvarchar(200)                                   
PubDate        datetime                   &nbs


Ïà¹ØÎĵµ£º

¼¸¸öɾ³ýÖØ¸´¼Ç¼µÄSQLÓï¾ä

±ÈÈçÏÖÔÚÓÐÒ»ÈËÔ±±í  £¨±íÃû£ºpeosons£©
ÈôÏ뽫ÐÕÃû¡¢Éí·ÝÖ¤ºÅ¡¢×¡Ö·ÕâÈý¸ö×Ö¶ÎÍêÈ«ÏàͬµÄ¼Ç¼²éѯ³öÀ´
select   p1.*   from   persons   p1,persons   p2   where   p1.id<>p2.id   and   p1.cardid &nbs ......

ÌØÊâSQLÓï¾ä

1.²éѯÁ¬½Óµ½Ä³Êý¾Ý¿âµÄÁ¬½ÓÊý
   select   count(*)   as   Á¬½ÓÊý   from   master..sysprocesses   where   db_name(dbid)='Êý¾Ý¿âÃû' ......

ÔÚSQL Server2005ÖÐÓÐÈçÏÂËĸöÅÅÃûº¯Êý

ÅÅÃûº¯ÊýÊÇSQL Server2005мӵŦÄÜ¡£ÔÚSQL Server2005ÖÐÓÐÈçÏÂËĸöÅÅÃûº¯Êý£º
¡¡¡¡1.row_number
¡¡¡¡2.rank
¡¡¡¡3.dense_rank
¡¡¡¡4.ntile¡¡¡¡
¡¡¡¡ÏÂÃæ·Ö±ð½éÉÜÒ»ÏÂÕâËĸöÅÅÃûº¯ÊýµÄ¹¦Äܼ°Ó÷¨¡£ÔÚ½éÉÜ֮ǰ¼ÙÉèÓÐÒ»¸öt_table±í£¬±í½á¹¹Óë±íÖеÄÊý¾ÝÈçͼ1Ëùʾ£º
¡¡¡¡Í¼1
¡¡¡¡ÆäÖÐfield1×ֶεÄÀàÐÍÊÇint£¬field2×Ö¶ ......

sqlµ÷ÓÅÖ® ѰÕÒÎÒÃÇ×î¸ÐÐËȤµÄÓï¾ä

Tuning an Application / Reducing Load
If your whole application is performing suboptimally, or if you are attempting to
reduce the overall CPU or I/O load on the database server, then identifying
resource-intensive SQL involves the following steps:
1. Determine which period in the day you would ......

Microsoft SQL Server 2005 JDBC Driver 1.1

Microsoft SQL Server 2005 JDBC Driver
1.1
¿ìËÙÃèÊö
ÏÂÔØ Microsoft SQL Server
2005 JDBC Driver 1.1£¬ÕâÊÇÒ»ÖÖ Type 4 JDBC Çý¶¯³ÌÐò£¬¿Éͨ¹ý J2EE£¨Java2 ÆóÒµ°æ£©Öеıê×¼ JDBC
Ó¦ÓóÌÐò±à³Ì½Ó¿Ú (API) ÌṩÊý¾Ý¿âÁ´½Ó¡£
±¾Ò³ÄÚÈÝ
¿ì
ËÙÏêϸÐÅÏ¢
¸Å
Êö
ϵ
ͳҪÇó
˵
Ã÷
Ïà
¹Ø×ÊÔ´
Æä
ËûÓû§ÕýÔÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ