Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

VS2008 Ìí¼ÓSQLServerÎļþ

VS2008 Ìí¼ÓSQLServerÎļþ  ¾­³£»áÅöµ½´íÎó£¬ÏÖÔÚ½«¼¸¸ö³£¼ûµÄ´íÎóÂÞÁÐһϣ¬
“´Ë°æ±¾µÄ sql server ²»Ö§³ÖÓû§ÊµÀýµÇ¼±êÖ¾¡£¸ÃÁ¬½Ó½«¹Ø±Õ¡£”
½â¾ö°ì·¨:
ÔÚÁ¬½ÓÊôÐÔµÄÉèÖÃÀï±ß,µã“¸ß¼¶”,½«User Instance ÉèÖÃΪfalse,ĬÈϵÄtrue,ËùÒԲŵ¼ÖÂÕâ¸öÎÊÌâµÄ³öÏÖ.
“ÓëSQL ServerÎļþ£¨*.mdf£©µÄÁ¬½ÓÒªÇó°²×°SQL Server2005²ÅÄÜÕý³£¹¤×÷£¬ÇëÈ·ÈÏÊÇ·ñ°²×°Á˸Ã×é¼þ£¬……”
µã½âVS2008 ->¹¤¾ß ->Ñ¡Ïî
 ÔÚ“ Êý¾Ý¿â¹¤¾ß ->Êý¾ÝÁ¬½Ó” SQLServerʵÀýÃû´Ê£¬ÉèÖÃΪ¿Õ


Ïà¹ØÎĵµ£º

SQLServer×Ô¶¯Ìá½»SQL

Èç¹ûÔÚSQL Server ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ,
¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ->
2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->ÆôÓõķ½¿òÄÚÊǹ´ºÅ->
·ÖÀà´¦¿ÉÑ¡ÔñÒ²¿É ......

ÔÚRed hat LinuxÏÂͨ¹ýODBCÁ¬½ÓSQLServer2000

Ò» ²âÊÔ»·¾³
Ò» ²âÊÔ»·¾³
²Ù×÷ϵͳ  Red Hat  As 2.1
Êý¾Ý¿â     SQLServer2000 installed in windows xp professional£¬ÎÒ¼Ù¶¨Êý¾Ý¿âÓÐÓû§autotest ÃÜÂëÊÇautotest£¬Êý¾Ý¿âÎļþÊÇatsdb
             ×¢Ò⣺ &n ......

ÓÃasp.net»¹Ô­Óë»Ö¸´sqlserverÊý¾Ý¿â

  
ÉÏ´Î×öÁ˸öÏîÄ¿£¬Éæ¼°µ½Êý¾Ý¿âµÄ»¹Ô­ºÍ»Ö¸´£¬µ½ÍøÉÏÕÒÁËһϣ¬ÊÇÀûÓÃSQLDMOʵÏֵģ¬Ö»ÒªÌí¼ÓSQLDMOÒýÓþͺÃÁË£¬È»ºóÀûÓÃϱߵÄÀàµÄ·½·¨¾Í¿ÉÒÔʵÏÖÁË¡£
ÎÒ°ÑÔ­×÷ÕßµÄÀàÀ©³äÁËһϣ¬¿ÉÒÔ×Ô¶¯Ê¶±ðweb.configÀï µÄÊý¾Ý¿âÁ¬½Ó×Ö·û´®£¬¿ÉÒÔͨ¹ý±äÁ¿ÉèÖû¹Ô­»Ö¸´µÄÐÅÏ¢¡£
ÐèҪעÒâµÄʱ»¹Ô­£¬»¹Ô­µÄʱºòÎÊÌ ......

SQLSERVERÒÉÎÊ

ÒÉÎÊ£º
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, - ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ