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
Ïà¹ØÎĵµ£º
Ò»°ãµÄÔ¶³Ì·ÃÎʵÄд³ÉÕâÑù£º
Data Source=IP;Initial Catalog=Êý¾Ý¿âÃû;UserID=Óû§Ãû;Password=ÃÜÂë
±¾µØ·ÃÎʵÄд³ÉÕâÑù£º
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;UserID=Óû§Ãû;Password=ÃÜÂë
Èç¹ûÊDZ¾µØµÄ£¬Í¨¹ýwindows×é¼þÑéÖ¤µÄ£¨Ò²¾ÍÊÇûÓÐÓû§Ãû£¬ÃÜÂëµÄ£©Ð´³ÉÕâÑù£º
Data Source=(local);Initial Cata ......
Õý³£µÇ½sql*plusµÄ²½ÖèÈçÏ£º
sbdatabase*orcl-/home/oracle>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Sun May 9 19:50:24 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn hmsimis/test@orcl
Connected.
SQL>
¿ÉÒÔ¿´µ½Ç°ÃæµÄÌáʾ·ûÊÇSQL£¬ÏÖÔÚÏëÐ ......
ÏÂÃæËùÓеÄSQLÓï¾ä¶¼ÊÇÕë¶Ôǰ׺Ϊwp_µÄ±í£¬Èç¹ûÄãµÄ±íǰ׺²»ÊÇwp_£¬Çë×öÏàÓ¦µÄÐÞ¸Ä
1.¸ü¸Äwordpress°²×°ºÍÊ×Ò³µØÖ·
Èç¹ûÄã¸ü»»ÓòÃû»òÕß°ÑwordpressµÄ°²×°Ä¿Â¼½øÐÐÁ˱䶯¾ÍÐèÒª½øÐÐÐ޸ģ¬
UPDATE wp_options SET option_value = replace(option_value, ‘¾ÉÍøÖ·’, ‘ÐÂÍøÖ·’) WHERE option_name ......
×òÌìÎÒµÄSQL£¨Microsoft SQL Server 2005 £©µÇ¼²»ÉÏÈ¥ÁË£¬ÔÀ´ÊdzöÏÖÁ˼¸¸öСÎÊÌ⣬ÏÖÔڼǼһÏÂÎҵĽâ¾öÕ⼸¸öÇé¿öµÄ°ì·¨¡££¨½â¾ö·½·¨ÓкܶàÖÖ£¬ÕâЩֻÊÇÎҵĽâ¾ö·½·¨£¬½ö¹©²Î¿¼£©
²éÕÒÎÊÌâµÄ¹ý³Ì£º£¨×¢£ºÓÃwindowsÕ˺ݹÊÇ¿ÉÒԵǼµÄ£©
µÚÒ»²½£ºÆô¶¯ËùÓÐÓëSQLÓйصķþÎñ£¬ÎÊÌâÒÀ¾É£»
µÚ¶þ²½£º²é¿´windows·À»ðǽ£¬±»Ä¬ ......
On BULK COLLECT
By Steven Feuerstein Oracle ACE
Best practices for knowing your LIMIT and kicking %NOTFOUND
I have started using BULK COLLECT whenever I need to fetch large volumes of data. This has caused me some trouble with my DBA, however. He is complaining that although my programs mig ......