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

SQL Server 2005 saµÇ½ʧ°ÜµÄ½â¾ö°ì·¨

 ½ñÌìÔڵǼsql2005µÄʱºò£¬ÏëÓÃsaµÄÑéÖ¤·½Ê½µÇ¼£¬·¢ÏֵǼ²»ÁË£¬ÔÚÍøÉϲéÁËÏ£¬°´ÕÕÏÂÃæµÄ¾Í¿ÉÒÔ½â¾ö¡£Ö®Ç°ÔÚ×°sql2005µÄʱºò£¬ÊÇÉèÖóÉwindowsÑéÖ¤·½Ê½µÇ¼µÄ¡£
 ¾ßÌå½â¾ö·½°¸ÈçÏ£º
1. ¿ªÆôsql2005Ô¶³ÌÁ¬½Ó¹¦ÄÜ,¿ªÆô°ì·¨ÈçÏÂ,
    ÅäÖù¤¾ß->sql serverÍâΧӦÓÃÅäÖÃÆ÷->·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷->´ò¿ªMSSQLSERVER½ÚµãϵÄ
Database Engine ½Úµã,ÏÈÔñ"Ô¶³ÌÁ¬½Ó",½ÓϽ¨ÒéÑ¡Ôñ"ͬʱʹÓÃTCP/IPºÍnamed pipes",È·¶¨ºó,ÖØÆôÊý¾Ý
¿â·þÎñ¾Í¿ÉÒÔÁË.
2.µÇ½ÉèÖøÄΪ,Sql server and windows Authentication·½Ê½Í¬Ê±Ñ¡ÖÐ,¾ßÌåÉèÖÃÈçÏÂ:
    manage¹ÜÀíÆ÷->windows Authentication(µÚÒ»´ÎÓÃwindows·½Ê½½øÈ¥),->¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖÐÑ¡ÔñÄãµÄÊý
¾Ý·þÎñÆ÷--ÓÒ¼ü>ÊôÐÔ>security>Sqlserver and windows Authentication·½Ê½Í¬Ê±Ñ¡ÖÐ.
3:ÉèÖÃÒ»¸öSql server·½Ê½µÄÓû§ÃûºÍÃÜÂë,¾ßÌåÉèÖÃÈçÏÂ:
    manage¹ÜÀíÆ÷->windows Authentication>new query>sp_password null,'sa123456','sa'      ÕâÑù
¾ÍÉèÖÃÁËÒ»¸öÓû§ÃûΪsa ,ÃÜÂëΪ:sa123456µÄÓû§,Ï´ÎÔڵǽʱ,¿ÉÒÔÓÃSql server·½Ê½,      Óû§ÃûΪ
sa ,ÃÜÂëΪ:sa123456µÄÓû§½øÊý¾Ý¿âÁË.
4: ×öÍêÉÏÃæÈý²½ºó,ÕâÑùдÁ¬½Ó×Ö·û´®¾Í¿ÉÒÔ˳Àû½øÈëÊý¾Ý¿âÁË,
     (server=.\\sqlexpress;uid=sa;pwd=sa123456;database=master";
ÉÏÃæÊÇÍøÉϵÄ˵·¨:×öÁË,²»¿ÉÒÔ
  ÐÂ×öÒ»±é,µÚÈý²½ÊÇÓòéѯ·ÖÎöÆ÷ÔËÐÐµÄ sp_password null,'sa123456','sa'    È»ºóÖØÐÂÆô¶¯SQL
Server (SQLEXPRESS)·þÎñ Á¬½Ó Õý³£
-


Ïà¹ØÎĵµ£º

½â¾ö²¢Çå³ýSQL±»×¢Èë¶ñÒⲡ¶¾´úÂëµÄÓï¾ä

declare @t varchar(255),@c varchar(255)  
declare table_cursor cursor for select a.name,b.name   
from sysobjects a,syscolumns b ,systypes c   
where a.id=b.id and a.xtype='u'&n ......

sqlÓÅ»¯34Ìõ

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦À ......

SQLµÄÓÅ»¯

´ó¼Ò¶¼ÔÚÌÖÂÛ¹ØÓÚÊý¾Ý¿âÓÅ»¯·½ÃæµÄ¶«¶«£¬¸ÕºÃ²ÎÓ뿪·¢ÁËÒ»¸öÊý¾Ý²Ö¿â·½ÃæµÄÏîÄ¿£¬ÒÔϵÄÒ»µã¶«Î÷ËãÊÇÊý¾Ý¿âÓÅ»¯·½ÃæµÄѧϰ+ʵսµÄһЩÐĵÃÌå»áÁË£¬ÄóöÀ´´ó¼Ò¹²Ïí¡£»¶Ó­ÅúÆÀÖ¸Õý°¢£¡
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼­£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQ ......

Ó°ÏìSQL serverÐÔÄܵĹؼüÈý¸ö·½Ãæ

1 Âß¼­Êý¾Ý¿âºÍ±íµÄÉè¼Æ
Êý¾Ý¿âµÄÂß¼­Éè¼Æ¡¢°üÀ¨±íÓë±íÖ®¼äµÄ¹ØϵÊÇÓÅ»¯¹ØϵÐÍÊý¾Ý¿âÐÔÄܵĺËÐÄ¡£Ò»¸öºÃµÄÂß¼­Êý¾Ý¿âÉè¼Æ¿ÉÒÔΪ
ÓÅ»¯Êý¾Ý¿âºÍÓ¦ÓóÌÐò´òÏÂÁ¼ºÃµÄ»ù´¡¡£
±ê×¼»¯µÄÊý¾Ý¿âÂß¼­Éè¼Æ°üÀ¨ÓöàµÄ¡¢ÓÐÏ໥¹ØϵµÄÕ­±íÀ´´úÌæºÜ¶àÁеij¤Êý¾Ý±í¡£ÏÂÃæÊÇһЩʹÓñê×¼»¯
±íµÄһЩºÃ´¦¡£
A:ÓÉÓÚ±íÕ­£¬Òò´Ë¿ÉÒÔʹŠ......

SQLÊý¾Ý¿â¿ìÕÕ


Êý¾Ý¿â¿ìÕÕÊÇMSSQL2005µÄй¦ÄÜ£¬½öÔÚ Microsoft SQL Server 2005 Enterprise Edition ÖпÉÓ᣶øÇÒSQL Server Management Studio ²»Ö§³Ö´´½¨Êý¾Ý¿â¿ìÕÕ£¬´´½¨¿ìÕÕµÄΨһ·½Ê½ÊÇʹÓà Transact-SQL¡£
Êý¾Ý¿â¿ìÕÕÊÇÊý¾Ý¿â£¨³ÆΪ“Ô´Êý¾Ý¿â”£©µÄÖ»¶Á¾²Ì¬ÊÓͼ¡£ÔÚ´´½¨Ê±£¬Ã¿¸öÊý¾Ý¿â¿ìÕÕÔÚÊÂÎñÉ϶¼ÓëÔ´Êý¾Ý¿âÒ»Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ