sqlserver2005Ô¶³ÌÁ¬½Ó mysql
sqlserver2005Ô¶³ÌÁ¬½Ó mysql
2ÖÖ·½·¨
Ò»ÊÇͨ¹ý½¨Á¢linkµÄ·½·¨
sp_addlinkedserver 'ntest-linkÃû', 'MySQL', 'MSDASQL--Ö§³ÖµÄÁ´½Ó·½Ê½', 'mytest-dsnÃû'
GO
sp_addlinkedsrvlogin 'ntest-linkÃû','false', 'sa-sqlserverÓû§','mythzz-sqlserverÃÜÂë'
¾ßÌå¿ÉÒԲο¼ °ïÖúÎĵµ
select * from ntest..pdns.tt
µ«ÊÇÎÒʽÁË Ìáʾ¾Ü¾øÓû§ÐèÒªÃÜÂë
Driver]Access denied for user
µÈ¿ÕÁËÔÚ¸ãÏÂ
µÚ¶þÖÖ·½·¨ÊÇÖ±½ÓÓÃ
OPENROWSETÓëOPENQUERY£¨¾ßÌå¿ÉÒÔ²ésql°ïÖúÎĵµ£©
¿ªÆôÊý¾Ý¿âÑ¡Ïî
SP_CONFIGURE 'show advanced options',1
GO
RECONFIGURE
GO
-- Ϊ¿ªÆôΪ¹Ø±Õ
SP_CONFIGURE 'Ad Hoc Distributed Queries',1
GO
RECONFIGURE
GO
SP_CONFIGURE 'show advanced options',0
GO
RECONFIGURE
SELECT *
from OPENROWSET('MSDASQL','mytest';'root';'mythzz',
'SELECT * from pdns.tt')
Ïà¹ØÎĵµ£º
sqlserver£ºupdate Table_A set Table_A.col1 = (select Table_B.col1 from Table_B where Table_A.col2 = Table_B.col2)
Access: UPDATE Table_ A, Table_B SET Table_ A.×Ö¶Î2 = Table_ B.×Ö¶Î2
WHERE Table_ A.񅧏=Table_ A.񅧏;
×Ô¼º¼ÇÏ£¬ÌáÐÑ×Ô¼º ......
1.°²×°ºÃSQLServer 2005Êý¾Ý¿âÈí¼þ£¬½Ó×Å×îÖØÒªµÄ¾ÍÊǰ²×°Êý¾Ý¿âÇý¶¯SQL Server 2005 driver for JDBC£¬¿ÉÒÔµ½:http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exeÏÂÔØ
2.½«JDBC½âѹµ½ÈÎÒâµÄλÖã¬ÔÚ°²×°Ä¿Â¼ÀïÕÒµ½sqljdbc.jarÎļþ£¬ÒÔǰµÄÎÄÕÂÖÐÒѾ½²¹ý» ......
±¾ÎÄת×Ô£ºhttp://blog.csdn.net/jinjazz/archive/2008/07/14/2650506.aspx
½«oledb¶ÁÈ¡µÄexcelÊý¾Ý¿ìËÙ²åÈëµÄsqlserverÖУ¬ºÜ¶àÈËͨ¹ýÑ»·À´Æ´½Ósql£¬ÕâÑù×ö²»µ«ÈÝÒ׳ö´í¶øÇÒЧÂʵÍÏ£¬×îºÃµÄ°ì·¨ÊÇʹÓÃbcp£¬Ò²¾ÍÊÇSystem.Data.SqlClient.SqlBulkCopy ÀàÀ´ÊµÏÖ¡£²»µ«Ëٶȿ죬¶øÇÒ´úÂë¼òµ¥£¬ÏÂÃæ²âÊÔ´ú ......
ÎÞÂÛÊÇÔÚsql 2000£¬»¹ÊÇÔÚ sql 2005 ÖÐ,¶¼Ã»ÓÐÌṩ×Ö·û´®µÄ¾ÛºÏº¯Êý£¬ËùÒÔ£¬µ±ÎÒÃÇÔÚ´¦ÀíÏÂÁÐÒªÇóʱ£¬»á±È½ÏÂé·³£ºÓбítb, ÈçÏ£ºid value----- ------1 aa1 bb2 aaa2 bbb2 cccÐèÒªµÃµ½½á¹û£ºid values------ -----------1 aa,bb2 aaa,bbb,ccc¼´£¬ group by id, Çó value µÄºÍ£¨×Ö·û´®Ïà¼Ó£©
1. ¾ÉµÄ½â¾ö·½·¨-- 1. ´´½¨´¦À ......
¼Ç¼һÏÂÒÔ±¸Ï´οìËÙÕÒµ½¡£¡£¡£
Íùtb_wf_privgrant±íÖвåÈëÒ»Ìõ¼Ç¼£¬workflow_id×Ö¶ÎÖµ´Ótb_wf_workflow ±íÖлñÈ¡workflow_name='֪ʶÉóºË'µÄËùÓмǼÖÐworkflow_id×î´óÖµ¡£
--oracle
declare a NUMBER(10);
begin
select max(wo ......