sql server browserºÍsql server sql server express
sql server browserºÍsql server sql server expressÊǸÉÂðµÄ
ÎÒÖ»ÊÇÓÃSQL2005×öÍøÕ¾Êý¾Ý¿â£¬ÇëÎÊ¿ÉÒÔ½ûÓÃÂð£¿
ÎÒÏë½ÚÔ¼·þÎñÆ÷×ÊÔ´
»¹ÓÐÒ»¸ösql server fill text search
Õâ¸öÓ¦¸ÃÊÇÈ«ÎÄËÑË÷°É£¬¿ÉÒÔÒ²¿ÉÒÔ½ûÓÃÂð
ding
sql server browser
ÕìÌýÐÒéʹÓ㬱¾»ú¿É¹Ø±Õ
sql server express
sqlserver¸½´øµÄÒ»¸öÃâ·ÑÊý¾Ý¿â£¬²»Ê¹ÓÿɹرÕ
¹Ø±ÕÏà¹Ø·þÎñ¾Í¿ÉÒÔÁË
Ïà¹ØÎÊ´ð£º
дSQLÓï¾ä£º
±í1£ºCLASS
º¬ÓÐÁ½¸ö×ֶΣºID£¬CLASSNAME,±í½á¹¹ÈçÏ£º
ID CLASSNAME
1 A
2 B
3 C
4 D
±í2£ºSTUDENT
º¬ÓÐÈçÏÂ×ֶΣºS ......
ÒªÊäÈëUSE <Êý¾Ý¿âÃû>ʱ£¬ÒªÓõ½SQL±à¼Æ÷£¬µ«²»ÖªµÀÔÚʲôµØ·½£¬¸ßÊÖ°ï°ïæѽ£¡
SQL2005 µã»÷ÓÒÉϽǵÄ--н¨²éѯ(N)
Êó標選擇Òª²é詢µÄ數據庫£¬È»á ......
ÏÖÔÚÓÐÁ½Õűí
a±íºÍb±í
a±í:
¹¤ºÅ ÐÕÃû ËùÊô²¿ÃűàºÅ
001 A
002 B
003&n ......
ÎÒÏÖÔÚÓÐ2¸ö±íTable1£¬Table2¡£¶ÔÓ¦µÄ×ֶΡ¢Êý¾ÝÈçÏ£º
Table1£ºprimary key(a1)
a1(char) a2(int)
a 10
b & ......