ÇóÒ»¸ö³É¹¦µÄMSSQLÊý¾Ý¿âÉè¼ÆÀý×Ó
´óϺÃÇ£¬ÎÒÏë×öÒ»¸öÍøÕ¾µÄºǫ́Êý¾Ý¿â£¬ÓÃMSSQL½øÐÐÉè¼Æ£¬ÍøÕ¾µÄÀàÐÍÀàËÆÓÚ¹ºÎïÍøÕ¾£¬ÄÇôÎҵĺǫ́Êý¾Ý¿âÓ¦¸ÃÔõÑùÉè¼ÆÄØ£¿£¿
ÓÐûÓÐÒ»¸ö±È½Ï³É¹¦µÄÊý¾Ý¿âµÄÉè¼ÆÀý×Ó¹²ÔÚÏÂÑо¿Ò»Ï£¿£¿¼±Óõģ¬ÔÚÏߵȡ£¡£¡£¡£¡£
Äã²»ÈçÈ¥ÍøÉÏϸöÏà¹ØµÄϵͳ¿´¿´È˼ÒÔõô¸ãµÄ.
Õâ¸öÒª½áºÏÄãµÄÐèÇó·ÖÎöÀ´
Äã¿ÉÒԲο¼Ò»ÏÂÍøÉÏÏÂÔØµÄϵͳ£¬È»ºó¸ù¾Ý×Ô¼ºµÄÐèÇóÀ´ÐÞ¸Ä
´ó¼ÒºÃŶ
Ïà¹ØÎÊ´ð£º
MSSQL$SQLEXPRESS ÎÞ·¨Æô¶¯.. ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ лл
¿´¿´´íÎóÈÕÖ¾
Ìáʾʲô´íÎó?
http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......
mssqlÈçºÎÖ»ÏÔʾÓÐÖØ¸´µÄÊý¾ÝÄØ£¿
ÓÐÖØ¸´µÄÊý¾Ý¾ÍÏÔʾһÌõÖØ¸´µÄÊý¾Ý£¬Ã»Öظ´µÄ²»ÏÔʾ£¬²éѯÓï¾ä¸ÃÔõÃ´Ð´ÄØ£¿Ð»Ð»
SQL code:
select distinct *
from tablename
where id in (
selec ......
ÎÒ×°µÄÊÇWin2003ϵͳ£¬·Ö±ð°²×°ÁËsql server2000ºÍsql server2005£¬ÏÖÔÚ³öÏÖÁËһЩÎÊÌ⣬¾ÍÊÇÔÚ¾ÖÓòÍøÄÚÆäËüµÄµçÄÔÓÃSQL 2000ÎÞ·¨·ÃÎʵ½ÎÒµÄÊý¾Ý¿â~~Ìáʾ´íÎóΪ£ºSQL Server²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø£¬Ö®Ç°Ö»ÓÐSQL 2000µÄÊ ......
ÎÒµÄÓï¾äÈçÏ£º
$myServer = "124.172.125.197"; //Ö÷»ú
$myUser = "jmkjxy"; //Óû§Ãû
$myPass = "jmkjxy023"; //ÃÜÂë
$myDB = "jmkjxy"; //MSSQL¿âÃû ......