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

¹ØÓÚsql¸ü¸Ä¼ÆËã»úÃûºÍ·þÎñÆ÷ÃûÒ»Ö»ò"´íÎó 18483

½ñÌìÔÚÅäÖÃÊý¾Ý¿â·¢²¼ºÍ·Ö·¢Ê±×ÜÊDZ¨³öÏÖ 18483 ´íÎó
Ìáʾ˵£º´íÎó 18483:δÄÜÁ¬½Óµ½·þÎñÆ÷ "XXX"£¬ÒòΪ 'distributor_admin'δÔڸ÷þÎñÆ÷É϶¨ÒåΪԶ³ÌµÇ½¡£
Îҵķ¢²¼ºÍ·Ö·¢ÊÇͬһ¸ö·þÎñÆ÷£¬"XXX" ΪÎҵĻúÆ÷Ãû£¬·Ö·¢Êý¾Ý¿âÊÇĬÈϵÄÃû³Æ£¬¶øÎÒÔÚÁíÍâһ̨»úÆ÷ÉÏ×öʱ¾ÍÕý³£¡£
1¡¢ÉèÖù²Ïí¸´ÖÆÄ¿Â¼:
      \\computer_machine\C$...\..Èç¹û·þÎñÆ÷È¡Ïû¹ýĬÈϵĹ²Ïí£¨$)Ôò»áʧ°Ü£»´Ëʱн¨Ò»¸öĿ¼£¬²¢¸³ÓèȨÏÞ£¬Ä¿Â¼¸ÄΪ£º\\computer_machine\¹²ÏíĿ¼Ãû
2¡¢½¨Á¢ÓÃÓÚ·¢²¼Ó¦ÓõÄwindowsÕ˺Å
3¡¢ÔÚÅäÖ÷ַ¢·þÎñÆ÷ʱÔâÓöÁË ´íÎó18483 ÌáʾÒòΪdistributor_adminδÔڸ÷þÎñÆ÷É϶¨ÒåΪԶ³ÌµÇ½,¹ÊÎÞ·¨´´½¨
½â¾ö·½·¨£º(ÔËÐÐÒÔϳÌÐò£©
USE master
GO
--ÉèÖÃÁ½¸ö±äÁ¿
DECLARE @serverproperty_servername  varchar(100),
 @servername    varchar(100)
--È¡µÃWindows NT ·þÎñÆ÷ºÍÓëÖ¸¶¨µÄ SQL Server ʵÀý¹ØÁªµÄʵÀýÐÅÏ¢
--¾ßÌå¿ÉÒÔ¿´Áª»ú´ÔÊé"SERVERPROPERTY"
SELECT @serverproperty_servername = CONVERT(varchar(100), SERVERPROPERTY('ServerName'))
--·µ»ØÔËÐÐ Microsoft® SQL Server™ µÄ±¾µØ·þÎñÆ÷Ãû³Æ
--¾ßÌå¿ÉÒÔ¿´Áª»ú´ÔÊé@@SERVERNAME
SELECT @servername = CONVERT(varchar(100), @@SERVERNAME)
--Èç¹û@serverproperty_servernameºÍ@servername²»Í¬(ÒòΪÄã¸Ä¹ý¼ÆËã»úÃû×Ö),ÔÙÔËÐÐÏÂÃæµÄ
--ɾ³ý´íÎóµÄ·þÎñÆ÷Ãû
EXEC sp_dropserver @server=@servername
--Ìí¼ÓÕýÈ·µÄ·þÎñÆ÷Ãû
EXEC sp_addserver @server=@serverproperty_servername, @local='local'
2:×Þ½¡´ð¸´µÄ:
--³öÏÖÕâÖÖÎÊÌâ,Ó¦¸ÃÊÇÄãÔø¾­¸ü¸Ä¹ý¼ÆËã»úÃû
--Ö´ÐÐÏÂÃæµÄÓï¾ä,Íê³ÉºóÖØÐÂÆô¶¯SQL·þÎñ
if serverproperty('servername') <> @@servername
begin
declare @server sysname
set @server = @@servername
exec sp_dropserver @server = @server
set @server = cast(serverproperty('servername') as sysname)
exec sp_addserver @server = @server , @local = 'LOCAL'
end
µ«ÊÇÎÒÖ´ÐÐÍêÉÏÃæµÄSQL,ÖØÆô·þÎñÒÔºó,»¹ÊDZ¨Í¬ÑùµÄ´íÎó.×îºó³¢ÊÔ×ŰÑ×¢²áÃûÊÖ¶¯¸ü¸ÄµÄºÍ¼ÆËã»úÃûÒ»ÖÂ,½á¹û¾ÍOKÁË.


Ïà¹ØÎĵµ£º

ת SQL server ÓëOracle¿ª·¢±È½Ï

Ô­ÎĵØÖ·£ºhttp://www.cnblogs.com/wangxiaohuo/archive/2008/04/20/1162631.html
 
±¾ÎĵµÖ÷Òª´ÓoracleÓësql serverÓï·¨ÉϽøÐвîÒìÐԱȽϣ¬ÖîÈçÁ½ÕßÔÚ¹ÜÀí£¬ÐÔÄÜ£¬ÓÅ»¯µÈ·½ÃæµÄ²îÒì²»×÷±È½Ï¡£
¡ñ¸ÅÄîÉÏÇø±ð
   1.Oracle ÊÇÒ»ÖÖ¶ÔÏó¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¨ORDBMS),¶øSql server Ö»ÊǹØÏµÐÍÊý¾Ý¿â¹Ü
&nbs ......

Ö´Ðлº´æÒÔÓÅ»¯SQL ServerµÄÄÚ´æÕ¼ÓÃ

×÷Õߣºsuperhasty
  2007-11-29
ÔÚÂÛ̳Éϳ£¼ûÓÐÅóÓѱ§Ô¹£¬ËµSQL ServerÌ«³ÔÄÚ´æÁË¡£ÕâÀï±ÊÕ߸ù¾Ý¾­Ñé¼òµ¥½éÉÜÒ»ÏÂÄÚ´æÏà¹ØµÄµ÷ÓÅ֪ʶ¡£Ê×ÏÈ˵Ã÷Ò»ÏÂSQL
ServerÄÚ´æÕ¼ÓÃÓÉÄ¿·Ö×é³É¡£SQL ServerÕ¼ÓõÄÄÚ´æÖ÷ÒªÓÉÈý²¿·Ö×é³É£ºÊý¾Ý»º´æ(Data
Buffer)¡¢Ö´Ðлº´æ(Procedure Cache)¡¢ÒÔ¼°SQL ServerÒýÇæ³ÌÐò¡£S ......

1.ʲô½ÐSQL×¢È룿ÈçºÎ·ÀÖ¹£¿Çë¾ÙÀý˵Ã÷

1.ʲô½ÐSQL×¢È룿ÈçºÎ·ÀÖ¹£¿Çë¾ÙÀý˵Ã÷
´ð£ºSQL×¢ÈëÊdz£¼ûµÄÀûÓóÌÐò©¶´½øÐй¥»÷µÄ·½·¨¡£µ¼ÖÂsql×¢Èë¹¥»÷²¢·ÇϵͳÔì³ÉµÄ£¬Ö÷ÒªÊdzÌÐòÖкöÂÔÁ˰²È«ÒòËØ£¬ÀûÓÃsqlÓïÑÔ©¶´»ñµÃºÏ·¨Éí·ÝµÇ½ϵͳ 
ÀýÈ磺
"Select * from users where name='"+uName+"' and pwd='"+uPwd+"' " ......

SQL Server 2005ÎÞ·¨Æô¶¯~£¡£¡£¡£¡

2010-05-05 13:35:52.06 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2010-05-05 13:35:52.06 Server (c) 2005 Microsoft Corporation.
201 ......

SQL ΪÖ÷±íµÄıһÌõ¼Ç¼£¬ÔÚÖмä±íÖÐͬʱ²åÈë¶àÌõÊý¾Ý

ÓÐʱÎÒÃÇ»áÏñÏÂÃæµÄÇé¿öÒ»Ñù£¬ÎªÖ÷±íµÄıһÌõ¼Ç¼£¬ÔÚÖмä±í(T_Stud_Course ±í)ÖÐͬʱ²åÈë¶àÌõÊý¾Ý
T_Student ±í
Stud_ID
Name
1
Tom
2
Jack
T_Course ±í
Course_ID
Course
1
Chinese
2
English
T_Stud_Course ±í
ID
Stud_ID
Course_ID
1
1
1
2
1
2
3
2
2
 
ÏÖÔÚÎÒÃÇ¿ÉÒÔÏÂÃæµÄ´æ´¢¹ý³ÌÀ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ