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

SQL SERVER 2005 °²×° - MS-SQL Server / »ù´¡Àà

ΪʲôÎÒ×°µÄSQL SERVER 2005ûÓÐʾÀýÊý¾Ý¿â£¿
ÊDz»Êǰ汾ÎÊÌ⣡£¡
XPÀïÃæ×îºÃ°²×°SQL SERVER 2005¿ª·¢°æ

ΪʲôÎÒ×°µÄSQL SERVER 2005ûÓÐʾÀýÊý¾Ý¿â£¿

ÓÐЩ°æ±¾ÊÇûÓеÄ,

×Ô¼ºÈ¥ÍøÕ¾ÏÂÔØÊ¾ÀýÊý¾Ý¿â¾ÍÐÐÁË

ÎÒÑ¡Ôñ°²×°Ê¾ÀýÊý¾Ý¿âÁË£¬¿ÉÊÇÁ¬½ÓµÄʱ¼ä³öÏÖÏÂÃæÌá ʾ

Äã°²×°µÄʱºò ÊÇÑ¡ÔñĬÈÏʵÀýÃûÂð£¿Èç¹ûÊǵϰ·ÃÎÊʱ²»ÐèÒª \ʵÀýÃû£¬Ö»ÐèÓ÷þÎñÆ÷Ãû»òIP·ÃÎʾͿÉÒÔÁË

ÒýÓÃ
Äã°²×°µÄʱºò ÊÇÑ¡ÔñĬÈÏʵÀýÃûÂð£¿Èç¹ûÊǵϰ·ÃÎÊʱ²»ÐèÒª \ʵÀýÃû£¬Ö»ÐèÓ÷þÎñÆ÷Ãû»òIP·ÃÎʾͿÉÒÔÁË


²»ÊÇÑ¡ÔñµÄĬÈÏʵÁС£×ÔÒÑдÁËһʵÀýÃû×ÖMYDB


ytmytmллÁË

ÍøÉÏÓа²×°ÊÓÆµ½Ì³ÌµÄ ×Ô¼ºÈ¥¿´¿´°É

²»¶®°¡¡£¡£¡£¡£

Òª²»»»¸ö°æ±¾£¡£¡£¡

ÒýÓÃ
ΪʲôÎÒ×°µÄSQL SERVER 2005ûÓÐʾÀýÊý¾Ý¿â£¿

ÄãÔÚ°²×°µÄʱºò,ҪѡÔñʾÀýÊý¾Ý¿â.¾ÍÊÇÓиöÏÂÀ­¼ýÍ·,Ñ¡Ôñ°ÑËùÓй¦Äܰ²×°ÔÚ±¾»ú.


ÍøÉÏÓн̳̿´¿´°É


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

sql ²éѯ - MS-SQL Server / »ù´¡Àà

ÓÐTABLEA ×Ö¶ÎΪ ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ  
ÏÖÏë°´ÕÕÎïÁϱàÂë²éѯ×î´óÈë¿âÈÕÆÚ
Óï¾äÈçÏ£º
SELECT ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ from TABLEA A WHERE Èë¿âÈÕÆÚ=(SELECT MAX(Èë¿âÈÕÆÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ