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

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()º¯ÊýʹÓ÷½·¨

SQL ÖÐµÄ TRIM º¯Êý
ÊÇÓÃÀ´ÒƳýµôÒ»¸ö×Ö´®ÖеÄ×ÖÍ·»ò×Öβ¡£×î³£¼ûµÄÓÃ;ÊÇÒƳý×ÖÊ×»ò×ÖβµÄ¿Õ°×¡£Õâ¸öº¯ÊýÔÚ²»Í¬µÄ×ÊÁÏ¿âÖÐÓв»Í¬µÄÃû³Æ£º
MySQL: TRIM(), RTRIM(), LTRIM()
Oracle: RTRIM(), LTRIM()
SQL Server: RTRIM(), LTRIM()
¸÷ÖÖ trim º¯ÊýµÄÓï·¨ÈçÏ£º
TRIM ([[λÖÃ] [ÒªÒƳýµÄ×Ö´®] from ] ×Ö´®): [λÖà ......

SQL Server 2008µÄ¹ÜÀí¹¤¾ßÒªÏûºÄ¸ü¶àµÄÄÚ´æ

2008µÄSSMS±È2005°æÒª¶àÏûºÄÒ»±¶×óÓÒµÄÄڴ棬¶øÇÒËƺõ²»»á×Ô¼ºÊÍ·Å£¬ÖÁÉÙÒ²ÊÇÄÚ´æ¹ÜÀí²»ÊǺܺÏÀí£¬ÍùÍù´ò¿ª¼¸¸ö²éѯ´°¿Ú½øÐвéѯºóÄÚ´æ¾Í»áÉýµ½ÄÑÒÔ200MBµ½300MB£¬ÇҹصôºóÄÚ´æ²»»áÊÍ·Å£¬¶ø2005µÄSSMSÒ»°ãÖ»ÊÇÔÚ100MB×óÓÒ¡£¶ÔÓµÓдóÄÚ´æµÄµçÄÔÀ´ËµÕâ¿ÉÄܲ»Ëãʲô£¬µ«¶ÔÄÚ´æÖ»ÓÐ1G»ò¸üÉÙµÄÓû§À´Ëµ£¬Õ⼸ºõÊDz»¿ÉÈÝÈ̵ģ¬ÒòÎ ......

java±¸·Ýsql serverÊý¾Ý¿â ´æ´¢¹ý³Ì

½ñÌì¸ø´ó¼Ò·ÖÏíÒ»ÏÂÈçºÎ±¸·ÝºÍ»Ø¸´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Óï¾äÖ®·ÖÎöº¯Êý(Èý)

±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Ò»)--sum()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(¶þ)--max()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Èý)--row_number() /rank()/dense_rank()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(ËÄ)--lag()/lead()
ÓÐЩʱºòÎÒÃÇÏ£ÍûµÃµ½Ö¸¶¨Êý¾ÝÖеÄÇ°nÁУ¬Ê¾ÀýÈçÏ£º
µÃµ½Ã¿¸ö²¿ÃÅнˮ×î¸ßµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ