64λSQL Server2005·ÃÎÊ32λSQL Server2000µÄÎÊÌâ
HR·þÎñÆ÷£º ²Ù×÷ϵͳ->32λWindows2000 SP4 Êý¾Ý¿â->32λSQL Server2000
OA·þÎñÆ÷£º ²Ù×÷ϵͳ->64λWindows2003 SP2 Êý¾Ý¿â->64λSQL Server2005
OAÏîÄ¿ÖУ¬ÐèÒª´ÓHR·þÎñÆ÷ÖÐÈ¡µÃÓû§µÄÊÖ»úºÅ¡£¶ÔÕâÖÖÇé¿ö£¬ÎÒÒÔÇ°¶¼ÊÇʹÓý¨Á¢Á´½Ó·þÎñÆ÷µÄ·½Ê½£¬ÓÚÊÇ£¬ºÜ¿ìµØдºÃ½Å±¾£¬°ÑHR·þÎñÆ÷×¢²áÁË£º
exec sp_dropserver 'HRServer', 'droplogins'
exec sp_addlinkedserver 'HRServer', '', 'SQLOLEDB', '10.101.166.38'
exec sp_addlinkedsrvlogin 'HRServer', 'false', null, 'sa', 'buaa369'
È»ºóÖ´ÐвéѯÓï¾ä£º
select top 10 * from HRServer.testdb.dbo.EmpContactMethod
½á¹û£¬²¢Ã»ÓгöÏÖÊìϤµÄÏÔʾ¼Ç¼»Ã棬ֱ½Ó±¨´íÁË¡£¡£¡££¨Ó¢Îİ棩
OLE DB provider "SQLNCLI" for linked server "hrserver" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "hrserver" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
ÏûÏ¢ 53£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 0 ÐÐ
Named Pipes Provider: Could not open a connection to SQL Server [53].
´Ëʱ£¬Èç¹ûÔÚÆóÒµ¹ÜÀíÆ÷ÖÐ×¢²áÕâ¸öHR·þÎñÆ÷£¬×öÏàÓ¦µÄ²éѯ¶¼Ã»ÎÊÌâ°¡¡£¡£¡£¡£
ÕâºÜÄÖÐÄÄÅ¡£
µ½CSDNÉϵÚÒ»´ÎÇóÖú£¬ËµÊÇ°æ±¾²»¶Ô£¬ÐèÒªSQL Server2000Ðè°²×°SP3»òSP4²¹¶¡¡£
¸½°æ±¾²éѯ½Å±¾£ºSELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
°æ±¾ºÅ¶ÔÓ¦£º
&nbs
Ïà¹ØÎĵµ£º
SQL ÖÐµÄ TRIM º¯Êý
ÊÇÓÃÀ´ÒƳýµôÒ»¸ö×Ö´®ÖеÄ×ÖÍ·»ò×Öβ¡£×î³£¼ûµÄÓÃ;ÊÇÒƳý×ÖÊ×»ò×ÖβµÄ¿Õ°×¡£Õâ¸öº¯ÊýÔÚ²»Í¬µÄ×ÊÁÏ¿âÖÐÓв»Í¬µÄÃû³Æ£º
MySQL: TRIM(), RTRIM(), LTRIM()
Oracle: RTRIM(), LTRIM()
SQL Server: RTRIM(), LTRIM()
¸÷ÖÖ trim º¯ÊýµÄÓï·¨ÈçÏ£º
TRIM ([[λÖÃ] [ÒªÒƳýµÄ×Ö´®] from ] ×Ö´®): [λÖà ......
2008µÄSSMS±È2005°æÒª¶àÏûºÄÒ»±¶×óÓÒµÄÄڴ棬¶øÇÒËƺõ²»»á×Ô¼ºÊÍ·Å£¬ÖÁÉÙÒ²ÊÇÄÚ´æ¹ÜÀí²»ÊǺܺÏÀí£¬ÍùÍù´ò¿ª¼¸¸ö²éѯ´°¿Ú½øÐвéѯºóÄÚ´æ¾Í»áÉýµ½ÄÑÒÔ200MBµ½300MB£¬ÇҹصôºóÄÚ´æ²»»áÊÍ·Å£¬¶ø2005µÄSSMSÒ»°ãÖ»ÊÇÔÚ100MB×óÓÒ¡£¶ÔÓµÓдóÄÚ´æµÄµçÄÔÀ´ËµÕâ¿ÉÄܲ»Ëãʲô£¬µ«¶ÔÄÚ´æÖ»ÓÐ1G»ò¸üÉÙµÄÓû§À´Ëµ£¬Õ⼸ºõÊDz»¿ÉÈÝÈ̵ģ¬ÒòÎ ......
½ñÌì¸ø´ó¼Ò·ÖÏíÒ»ÏÂÈçºÎ±¸·ÝºÍ»Ø¸´sql server Êý¾Ý£¬
Ê×ÏÈÈ·±£Äã¾ßÓÐDBµÄ×î¸ßȨÏÞ
ÔÚJAVA´úÂëÖÐ Äã¿ÉÒÔÕâÑùдpublic class Opp extends TestCase{
public void test1()
{
try
{
Connection con = DBUtils.getConn();
String sql="backup database tdzl to disk='d:\\tdzl.bak'";
Statement st = con.c ......
±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Ò»)--sum()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(¶þ)--max()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Èý)--row_number() /rank()/dense_rank()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(ËÄ)--lag()/lead()
ÓÐЩʱºòÎÒÃÇÏ£ÍûµÃµ½Ö¸¶¨Êý¾ÝÖеÄÇ°nÁУ¬Ê¾ÀýÈçÏ£º
µÃµ½Ã¿¸ö²¿ÃÅнˮ×î¸ßµÄ ......