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, -S(local) -Usa -P '
SELECT @error
µ±·¢ÉúÎļþÄÚÈÝ´íÎó³öÏÖ¡¾Error = [Microsoft][ODBC SQL Server Driver]BCP ¥Çー¥¿¥Õ¥¡¥¤¥ëÖФÇÓèÆÚ¤·¤Ê¤¤ EOF ¤¬検³ö¤µ¤ì¤Þ¤·¤¿¡£¡¿Ê±£¬@error²»ÄÜÈ¡µÃ´íÎ󣬵«ÊÇÎļþ²»´æÔڵȡ¾Error = [Microsoft][ODBC SQL Server Driver]Ò»À¨¥³¥Ôー ¥Û¥¹¥È¤Î¥Çー¥¿¥Õ¥¡¥¤¥ë¤¬開¤±¤Þ¤»¤ó¡£¡¿´íÎóʱ£¬@errorÄÜÈ¡µÃ´íÎó1¡£
2£¬ ´æ´¢¹ý³ÌÖУ¬Ê²Ã´ÑùµÄ´íÎó»áµ¼Ö³ÌÐòÖÕÖ¹£¬²»ÔÙÖ´ÐкóÃæµÄÓï¾ä£¬Ê²Ã´ÑùµÄ´íÎó»á±¨´íºó¼ÌÐøÖ´ÐУ¿
¹Û²ì£º
ÓеĴíÎóÖ»Ìø¹ý´íÎóµÄÓï¾ä¼ÌÐøÖ´ÐУ¬±ÈÈç×Ö·û´®¹ý³¤½Ø¶Ï£»
ÓеĴíÎó»áÖÕÖ¹µ±Ç°ËùÔÚ´æ´¢¹ý³Ì£¬µ«ÊÇ»á¼ÌÐøÖ´Ðд洢¹ý³ÌÍâµÄÓï¾ä£¬±ÈÈçselect Ò»¸ö²»´æÔÚµÄ±í£»
ÓеĴíÎó»áÖÕÖ¹Õû¸ö½ø³Ì£¬±ÈÈçtrucateÒ»¸ö²»´æÔÚµÄ±í¡£
Ïà¹ØÎĵµ£º
Author URL:http://www.cnblogs.com/xbf321/archive/2008/11/02/1325067.html
Microsoft URL:http://technet.microsoft.com/zh-cn/library/ms188001.aspx
ÕªÒª
1,EXECµÄʹÓÃ
2£¬sp_executesqlµÄʹÓÃ
MSSQLΪÎÒÃÇÌṩÁËÁ½ÖÖ¶¯Ì¬Ö´ÐÐSQLÓï¾äµÄÃüÁ·Ö±ðÊÇEXECºÍsp_executesql;ͨ³ ......
½ñÌì±àдÁËÒ»¸ö·ÖÒ³£¬ÔÚµ÷ÊÔÖгöÏÖÁËÈçϵĴíÎó:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid call Statement method: {0}
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown ......
JAVA Á¬½Ó SQLServer 2000 ËùÐèÒªµÄÈý¸öJAR°ü¡£
http://download.csdn.net/source/2283940
----------------
Code:
------------------------
Connection conn = null;
Statement sta = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServer ......
ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§Us ......
SQLServer CodeSmith C#
bigint Int64   ......