ÊÖ»ú¿ª·¢sqlserver ´´½¨·¢²¼
ÎÒÔÚѧϰʹÓÃSQL Server Compact Edition´´½¨Òƶ¯Ó¦ÓóÌÐò£¬¿ÉÊÇÔÚÊý¾Ý¿â´´½¨·¢²¼µÚÒ»²½Ê±Ìáʾ´íÎóÈçÏ£º
There are no publications to which you subscribe,either because this server has no publications or because you do not have sufficient privileges to access the publications.
Õâ¶ÎÓ¢ÎÄÎÒ¿ÉÒÔ¿´¶®£¬µ«ÊDz»ÖªµÀÔõô½â¾öÕâ¸öÎÊÌ⣬»¹Çë¸÷λ´óÏÀÃÇ°ïæ¡£
..
¡£
лл´ó¼Ò¹Ø×¢
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥ÁË°¡£¿
......
1.Ôõô°ÑÊý¾Ý´ÓsqlserverÀïÃæµÄÊý¾ÝдÈëµ½Ö¸¶¨Â·¾¶µÄexcel
±ÈÈç
declare @¹«Ë¾Ãû³Æ char(50)
set @¹«Ë¾Ãû³Æ = (select ¹«Ë¾Ãû³Æ from ¹«Ë¾ÐÅÏ¢)
EXEC [master]..xp_cmdshell 'bcp "select * from [master]. ......
Order by ʱ¼ä×ֶΠdesc
ÅŲ»ÁË˳ÐòÁË
Ç°ÌáÊÇÎÒÕâ¸öÊÇÒ»¸öÊÔͼ£¿
ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡£¡ºÜÊÇÓôÃÆ£¡Ï£Íû¸÷Ϊ¸ßÊÖÖ¸µã£¡£¡
¼±¼±£¡£¡£¡£¡
ËûÔÚÐÞ¸ÄÊ ......
SELECT *
INTO newtable
from OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\DB.mdb";User ID=Admin;Password=' )...±íÃû
Õâ¸ö Êý¾Ýµ¼ÈëµÄ ÆäÖкóÃæµÄ ...±íÃû ......
SQLSERVER ÎÒÓÐÒ»¸ö±í£¬²é³öÀ´µÄÒ»¸ö×Ö¶ÎÊÇ×Ö·û´®±í´ïʽ
±ÈÈç
a b c 5*6-3
a be ce 15*(6-3)
a b c 36-3
a be ce 1*(9-8)
ÎÒÏëÔڴ˺óÃæÔö ......