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

SQL°æÍí¼äÐÂÎÅ

±¾½ÚÄ¿ÓÉ£º
±í½ã      ×ÔÐŵÄÅ®ÈË×îÃÀÀö
Ê÷¸ç      Ê®ÄêÊ÷ľ£¬°ÙÄêÊ÷ÈË
Ë®¸ç      ˮˮ¸ü½¡¿µ
ÁªºÏÔÞÖú²¥³ö
----------------------------------------------------------------------------------------------------
¹ÛÖÚÅóÓÑÍíÉϺ㬽ñÌìÊÇ2009Äê9ÔÂ14ºÅ£¬Å©ÀúÆßÔ¶þÊ®Áù¡£»¶Ó­ÊÕ¿´Íí¼äÐÂÎÅ£¬ÎÒÊÇ¿¾Ñ¼
±¾Ê±¶ÎµÄÖ÷ÒªÄÚÈÝÓУº
¡¾°æÄÚÒªÎÅ¡¿
ÎÒ°æÃñ¾¯¿ªÕ¹ÐÂÒ»ÂÖɨ»Æ´ò·ÇÐж¯£¬ÈºÖÚ½»Ê׳ÆÔÞ
µçÊǪ́³¤Å­³âÐÐÒµ¸¡¿äÐé¼ÙÖ®·ç£ºÄãÃǵÄרҵ¾«ÉñÔÚÄÄ£¿
±¾Ì¨¼ÇÕßÒªÇóÕþ¸®¹«²¼ÀúÊ·×ÊÁÏ£¬Õþ¸®·¢ÑÔÈËÓèÒÔ»ØÓ¦

¡¾ÓéÀÖ°ËØÔ¡¿
ʧÁµ²»Ê§²Å£¬ÉËÐÄÃÀÄÐ×Ó»¯±¯Í´Îª×÷Æ·
СѧÌâÄ¿Äѵ¹Î¢ÈíMVP £¬¡°°®ÇéʹÈ˱äɵ¡±µÃµ½ÁÙ´²ÑéÖ¤
Ò»¿ÅÌǹûÒý·¢Éç»á´óÌÖÂÛ£ºÎÒÃǸÃÈú¢×Óѧ»áʲô
Å®×ÓÕ÷»é£º³ÏÕ÷·¿×ÓÒ»Ãû
¶Ô¶Ô×Ó½âѹÁ¦·¨ÎÊÊÀ£¬×¨¼Ò³ÆÓÐÍûÌæ´úÄó·½±ãÃæ¡£ÌåÑéÕߣº¶ÔÍêÒÔºó¸üÀÛÁË
----------------------------------------------------------------------------------------------------
¹ã¸æÍ¬Ñù¾«²Ê

С°®£ºÕæÐÄʵÒâÕÒʦ¸µ
ZS£ºÕ÷»é¡£ÒªÇó£ºÅ®µÄ£¬»îµÄ¡£
±í½ã£º³ÁÓãÂäÑã±ÕÔÂÐß»¨ÎÂÈá¶ËׯÊÊÁäÅ®Ñý³ÏÕ÷ÌÆÉ®Ò»Ãû
С³æ:³ÏÕ÷ÊÊÁä´ÆÐÔС³æÒ»Ãû¹²¶ÈÓàÉú£¬ÒªÇó£ºÉ«ÔóÏÊÁÁ£¬ÅÀÐÐËÙ¶ÈÖеȣ¬ÉíÌ彡¿µÎÞÒìζ

----------------------------------------------------------------------------------------------------
»¶Ó­»ØÀ´
ÏÂÃæ¹Ø×¢Ò»ÏÂÃ÷ÌìµÄÌìÆø£º
ÇïÌìµ½ÁËÌìÆø¿ªÊ¼±äÀ䣬Çë´ó¼Ò×¢Òâ·Àº®¹ã¶«Ò»´øµÄÅóÓÑÇëÎÞÊÓ

ÒÔÉϾÍÊDZ¾´ÎÐÂÎŵÄÈ«²¿ÄÚÈÝ£¬¸Ðл´ó¼ÒÊÕ¿´


Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

SQLÃÔ»ó

CREATE TABLE [Test_xcmtmp] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[subject] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Sourc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ