Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

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()
Èç¹ûÎÒÃÇ°´ÕÕʾÀýÏëµÃµ½Ã¿¸ö²¿ÃÅнˮֵ×î¸ßµÄ¹ÍÔ±µÄ¼Í¼£¬¿ÉÒÔÓÐËÄÖÖ·½·¨ÊµÏÖ£ ......

[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)

±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......

[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)

±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......

°²×°SQL Serverºó±Ø×ö12²½

12 Essential Steps After Installing SQL Server
By : Sadequl Hussain
Jul 13, 2009
 
from: http://www.sql-server-performance.com/articles/dba/post_installation_steps_p1.aspx
Rolling out SQL Servers is a key task for
DBAs.  While for some DBAs this can be a frequent exercise, others wi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ