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 table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
³ÌÐòʱASP+access
sql="select top 2 id,username from comp order by rnd(id) "
ÉÏÃæÓï¾äˢкó¶¼ÊÇÒ»¸öÖµ ÕâÑù»¹ÓÐËæ»úµÄÒâÒåÂð
ACCESSÓÐË¢ÐÂËæ»úÑ¡ÔñµÄSQLÓ ......
id name sfz
1 aa 410654198001204562
2 bb 410654198120461287
4 cc 41065419850 ......
±íA
¿¨ºÅ ʱ¼ä
1 null
2 null
3 & ......
ÏÖÔÚÓÐÁ½Õűí
a±íºÍb±í
a±í:
¹¤ºÅ ÐÕÃû ËùÊô²¿ÃűàºÅ
001 A
002 B
003&n ......