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

Êý¾Ý²Ù×÷Àà SQLHelper.cs
http://www.cnblogs.com/zengxiangzhan/archive/2009/12/31/1636871.html
ÎÞÏÞ¼¶·ÖÀà ´æ´¢¹ý³Ì
http://www.cnblogs.com/zengxiangzhan/archive/2010/01/04/1639220.html
°ÙÍò¼¶·ÖÒ³´æ´¢
http://www.cnblogs.com/zengxiangzhan/archive/2009/09/12/1565313.html
SQL¾­µä¶ÌС´úÂëÊÕ¼¯
htt ......

Java¡¢sql server 2000¼°jdbc

ÎÒÔÚѧϰ¹ØÓÚjava±à³Ì£¬ÏÖÔÚÉæ¼°µ½µÄÊÇsqlµÄÎÊÌ⣬±ÈÈçÈí¼þÑ¡Ôñ¡¢»·¾³µÄÁ¬½ÓÉèÖõÈÎÊÌ⣬¶ÔÓÚÕâЩÎÊÌâÎÒÕæÊÇÊøÊÖÎ޲߰¡£¡ÇëÇóJava±à³Ì¸ßÊִͽ̣º
      1¡¢ÎÒÓõÄJavaÊÇj2sdk-1_4_2_13-nb-5_0£¬ÎÒÓÃÁËsql server2000£¬ÎÒÓÃjdbc3.0ÐÐÂð£¿ËùÓÐÁ¬½ÓÉèÖøÃÔõôÑùÉèÖã¿
    &nb ......

sqlÓÅ»¯34Ìõ

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

SQL²éѯЧÂÊ 100wÊý¾Ý²éѯֻҪ1Ãë

»úÆ÷Çé¿ö
p4: 2.4
ÄÚ´æ: 1 G
os: windows 2003
Êý¾Ý¿â: ms sql server 2000
Ä¿µÄ: ²éѯÐÔÄܲâÊÔ,±È½ÏÁ½ÖÖ²éѯµÄÐÔÄÜ
SQL²éѯЧÂÊ step by step
-- setp 1.
-- ½¨±í
create table t_userinfo
(
userid int identity(1,1) primary key nonclustered,
nick varchar(50) not null default '',
classid int not nul ......

SQLÓï¾äµÃµ½´æ´¢¹ý³Ì¹ØÁªÄÄЩ±íÃû

SELECT DISTINCT '['+user_name(b.uid)+'].['+b.name+']' AS ¶ÔÏóÃû,b.type AS ÀàÐÍ
from sysdepends a,sysobjects b
WHERE b.id=a.depid
    AND a.id=OBJECT_ID('¹ý³ÌÃû');
 
 
EXEC SP_DEPENDS '¹ý³ÌÃû'; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ