VS2008 Ìí¼ÓSQLServerÎļþ
VS2008 Ìí¼ÓSQLServerÎļþ ¾³£»áÅöµ½´íÎó£¬ÏÖÔÚ½«¼¸¸ö³£¼ûµÄ´íÎóÂÞÁÐһϣ¬
“´Ë°æ±¾µÄ sql server ²»Ö§³ÖÓû§ÊµÀýµÇ¼±êÖ¾¡£¸ÃÁ¬½Ó½«¹Ø±Õ¡£”
½â¾ö°ì·¨:
ÔÚÁ¬½ÓÊôÐÔµÄÉèÖÃÀï±ß,µã“¸ß¼¶”,½«User Instance ÉèÖÃΪfalse,ĬÈϵÄtrue,ËùÒԲŵ¼ÖÂÕâ¸öÎÊÌâµÄ³öÏÖ.
“ÓëSQL ServerÎļþ£¨*.mdf£©µÄÁ¬½ÓÒªÇó°²×°SQL Server2005²ÅÄÜÕý³£¹¤×÷£¬ÇëÈ·ÈÏÊÇ·ñ°²×°Á˸Ã×é¼þ£¬……”
µã½âVS2008 ->¹¤¾ß ->Ñ¡Ïî
ÔÚ“ Êý¾Ý¿â¹¤¾ß ->Êý¾ÝÁ¬½Ó” SQLServerʵÀýÃû´Ê£¬ÉèÖÃΪ¿Õ
Ïà¹ØÎĵµ£º
Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ,
¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ->
2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->ÆôÓõķ½¿òÄÚÊǹ´ºÅ->
·ÖÀà´¦¿ÉÑ¡ÔñÒ²¿É ......
Ò» ²âÊÔ»·¾³
Ò» ²âÊÔ»·¾³
²Ù×÷ϵͳ Red Hat As 2.1
Êý¾Ý¿â SQLServer2000 installed in windows xp professional£¬ÎÒ¼Ù¶¨Êý¾Ý¿âÓÐÓû§autotest ÃÜÂëÊÇautotest£¬Êý¾Ý¿âÎļþÊÇatsdb
×¢Ò⣺ &n ......
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹ÔºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô£¬»¹ÔµÄʱºòÎÊÌ ......
ÒÉÎÊ£º
1£¬ sqlserverÀïÃæÖ´ÐÐ xp_cmdshell
exec @error=xp_cmdshell 'cmdstr......'
·µ»ØÖµÊÇʲôֵ£¿dosÃüÁîµÄ´íÎó£¿Ê²Ã´ÑùµÄ´íÎó¿ÉÒÔÆË×½µ½£¿
±ÈÈç:
DECLARE @error int
EXEC @error=master.dbo.xp_cmdshell 'bcp CM_DWHSend.dbo.WK_CM_DWHSend_Master in "D:\Sales\DWH_Onl\2010042_SENDMEMM.csv" -n -t, - ......