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

Óû§saµÇ¼ʧ°Ü,¸ÃÓû§Óë¿ÉÐÅsql serverÁ¬½ÓÎÞ¹ØÁª

Õâ¸öÓпÉÄÜÊÇÄãÔÚ°²×°SQL SERVER2005µÄʱºòÑé֤ģʽûÓÐÉèÖúÃ.
1.Ñ¡ÖзþÎñÆ÷(ÓÒ¼ü)->ÊôÐÔ->°²È«ÐÔ->·þÎñÆ÷Éí·ÝÑéÖ¤ÐÞ¸ÄΪ"SQL SERVERºÍWINDOWSÉí·ÝÑé֤ģʽ"
2.Õ¹¿ª·þÎñÆ÷ÉϵÄ"°²È«ÐÔ"->µÇ½Ãû->Ñ¡ÖÐSAµÇ½ÕʺÅ(ÓÒ¼ü)->״̬->µÇ½ÐÞ¸ÄΪÆôÓÃ.
 
°²×°ÍêSQL Serverºó,¿ÉÒÔÓÃWindowsÉí·ÝÈÏÖ¤µÇ¼,¾ÍÊDz»ÄÜÓÃsaÕË»§µÇ¼
½â¾ö²½Öè:1)½«µÇ¼·½Ê½ÉèΪ"»ìºÏÈÏÖ¤"(ÓÒ»÷·þÎñÆ÷->Ñ¡Ôñ"°²È«ÐÔ"->µãÑ¡"Sql Server"ºÍWindowsÉí·ÝÈÏ֤ģʽ)
2)ÉèÖÃsaÕË»§(Êý¾Ý¿â->°²È«ÐÔ(ÓëÉÏÃæµÄ²»ÊÇͬһ¸ö,Õâ¸ö²»ÓÃÓÒ»÷)->µÇ¼Ãû->saÕË»§->ÉèÖÃÃÜÂë->Óû§Ó³Éä->Ó³Éäµ½ÄãµÄÊý¾Ý¿â
 
Èç¹ûÔÚ°²×°¹ý³ÌÖÐÑ¡Ôñ¡°Windows  Éí·ÝÑé֤ģʽ¡±£¬Ôò  sa  µÇ¼½«±»½ûÓá£Èç¹ûÉÔºó½«Éí·ÝÑé֤ģʽ¸ü¸ÄΪ¡°SQL  Server  ºÍ  Windows  Éí·ÝÑé֤ģʽ¡±£¬Ôò  sa  µÇ¼ÈÔ´¦ÓÚ½ûÓÃ״̬¡£ÈôÒªÆôÓà sa  µÇ¼£¬ÇëʹÓà ALTER  LOGIN  ÃüÁî¡£ 
  sa  µÇ¼ֻÄÜʹÓà SQL  Éí·ÝÑéÖ¤Á¬½Óµ½·þÎñÆ÷¡£ 
   
  ÔÚ  SQL  Server  Management  Studio  ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖУ¬ÓÒ¼üµ¥»÷·þÎñÆ÷£¬ÔÙµ¥»÷¡°ÊôÐÔ¡±¡£ 
  ÔÚ¡°°²È«ÐÔ¡±Ò³Éϵġ°·þÎñÆ÷Éí·ÝÑéÖ¤¡±Ï£¬Ñ¡ÔñеķþÎñÆ÷Éí·ÝÑé֤ģʽ£¬ÔÙµ¥»÷¡°È·¶¨¡±¡£ 
  ÔÚ  SQL  Server  Management  Studio  ¶Ô»°¿òÖУ¬µ¥»÷¡°È·¶¨¡±ÒÔÈ·ÈÏÐèÒªÖØÐÂÆô¶¯  SQL  Server¡£ 
  ÔÚ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖУ¬ÓÒ¼üµ¥»÷ÄúµÄ·þÎñÆ÷£¬ÔÙµ¥»÷¡°ÖØÐÂÆô¶¯¡±¡£Èç¹ûÔËÐÐÓР SQL  Server  ´úÀí£¬ÔòÒ²±ØÐ뽫ÆäÖØÐÂÆô¶¯¡£ 
   
  Ö´ÐÐÏÂÁÐÓï¾äÒÔÆôÓà sa  ÃÜÂë²¢·ÖÅäÒ»¸öÃÜÂë¡£ 
  ALTER  LOGIN  sa  ENABLE  ; 
  GO 
  ALTER  LOGIN  sa  WITH  PASSWORD  =  ' <password>'  ; 
  GO 


Ïà¹ØÎĵµ£º

(Microsoft SQL Server£¬´íÎó: 3219)

MSSQL»¹Ô­Êý¾Ý¿âʧ°Ü£¬ÌáʾÈçÏ£º »¹Ô­¶ÔÓë·þÎñÆ÷ ʧ°Ü¡£(Microsoft.SqlServer.Smo) ÆäËüÐÅÏ¢£º ©§ ©»¡úÖ´ÐÐTransact-SQLÓï¾ä»òÅú´¦Àíʱ·¢ÉúÒì³£¡££¨Microsoft.SqlServer.ConnectionsInfo£© ©§ ©»¡ú²»ÄÜÑ¡ÔñÎļþ»òÎļþ×é¡°¡­¡­¡±ÓÃÓڴ˲Ù×÷¡£ RESTORE DATABASE ÕýÔÚÒì³£ÖÕÖ¹¡££¨Microsoft SQL Server, ´íÎó£º3219£© ³öÏÖ´Ë ......

PowerDesignerÉú³ÉSQL ERͼ ˵Ã÷Îĵµ

Ò»¡¢PowerDesignerÉú³ÉsqlÎÊÌâ
Éú³ÉsqlµÄ·½·¨ÊÇ Database -->Generate Database (Ctrl + G ) µ«ÊÇÌáʾ Could not load VBScript engine.
Check VBScript installation. Generation aborted due to errors detected during the verification of the model. ¼ì²éÁ˺þà ·¢ÏÖ½«check model È¥µô¾Í¿ÉÒÔÁË£¡ÆäÖУ¬ o ......

sql ÓαêµÄ»ù±¾Ó÷¨

1. ¶¨ÒåÓα궨Òå
ÓαêÓï¾äµÄºËÐÄÊǶ¨ÒåÁËÒ»¸öÓαê±êʶÃû£¬²¢°ÑÓαê±êʶÃûºÍÒ»¸ö²éѯÓï¾ä¹ØÁªÆðÀ´¡£DECLAREÓï¾äÓÃÓÚÉùÃ÷Óα꣬Ëüͨ¹ýSELECT²éѯ¶¨ÒåÓαê´æ´¢µÄÊý¾Ý¼¯ºÏ¡£Óï¾ä¸ñʽΪ£º
DECLARE ÓαêÃû³Æ [INSENSITIVE] [SCROLL]
CURSOR FOR selectÓï¾ä
[FOR{READ ONLY|UPDATE[OF ÁÐÃû×Ö±í]}]
²ÎÊý˵Ã÷£º
INSENSITIVEÑ¡Ï ......

SQL Server 2005Éý¼¶µÄ10¸öÀíÓÉ

SQL Server 2005Éý¼¶µÄ10¸öÀíÓÉ
¡¡ºÜ¶àÈ˹ØÐĵĺ͵£ÐĵĶ¼ÊÇ SQL Server 2005 Ïà¶ÔËüµÄÇ°°æ±¾SQL Server 2000Ëù×öµÄÖØ´ó¸Ä½ø»òÐÂÔö¹¦ÄÜ¡£ÔÚÎÒÉý¼¶µ½SQL2005Ö®ºó£¬²»µÃ²»ËµµÄ£ºÄãÒ²ÖµµÃÓµÓС£(Ì×ÓÃÒ»¾ä¹ã¸æÓºÇºÇ)
¡¡¡¡ÎÒ×ܽáÁËһϸöÈËÈÏΪSQL Server 2005 ÖÐ×îÖµµÃÄãΪ֮Éý¼¶µÄ10 ¸öÀíÓÉ¡£ÎÞÂÛÄãÊÇÏëÁ˽â»òѧϰSQL Se ......

SQL Server ÐÐÁÐת»»

ÔÚSQL SERVERÖУ¬ÓÐʱÐèÒªºÏ¶àÁÐÖµµ½ÐеÄÐèÇ󣬳£¼ûµÄ·½·¨ÓУº1.´´½¨×Ô¶¨Ò庯Êý£¬2.ʹÓÃÓα귨½øÐÐ×Ö·û´®ºÏ²¢¡£3.ʹÓÃÁÙʱ±íʵÏÖ×Ö·û´®ºÏ²¢¡£ Êý¾Ý£º DEPTNO EMPS
------ ----------
10 CLARK
10 KING
10 MILLER
20 SMITH
20 ADAMS
20 FORD
20 SCOTT
20 JONES
30 ALLEN
30 BLAKE
30 MARTIN
30 JAMES
30 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ