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

SQL Server 2005ÆôÓÃsaÕ˺Å


SQL Server 2005ÆôÓÃsaÕ˺Å
ÆôÓÃsaÓû§ºÍÔ¶³ÌÁ¬½Ó 
²Ëµ¥Start->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager 
Ñ¡ÖÐSQL Server 2005 Network Configuration 
ÔÚÓұߵÄTCP/IPÉϵãÓÒ¼ü£¬enabled 
²Ëµ¥Start->Microsoft SQL Server 2005->SQL Server Management Studio Express 
µÇ¼¶Ô»°¿òÖ±½Óµãconnect½øÈ¥ 
ÔÚ×ó±ß¸ù½áµã£¨yourpcSQLEXPRESS£©ÉϵãÓÒ½¨ 
Ñ¡properties 
×ó±ßÑ¡security£¬ÓÒ±ßÑ¡ÖÐSQL Server and Windows Authentication Mode 
¹¤¾ßÀ¸µÚÒ»¸ö°´Å¥new query 
ÔÚ²éѯ´°¿ÚÖÐÖ´ÐР
exec sp_password NULL,'yourpassword','sa' 
alter login sa enable 
¹Ø±ÕSQL Server Management Studio Express 
²Ëµ¥Start->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager 
Ñ¡ÖÐSQL Server 2005 Services 
ÔÚÓұߵÄSQL Server(SQLEXPRESS)ÉϵãÓÒ¼ü£¬Restart 
ÓÃsaµÇ¼ 
²Ëµ¥Start->Microsoft SQL Server 2005->SQL Server Management Studio Express 
µÇ¼¶Ô»°¿òAuthenticationÑ¡ÔñSQL Server Authentication 
µãconnect 
Èç¹û²»³öÒâÍâ,Ó¦¸Ã¿ÉÒԳɹ¦µÇ¼¡£ 
´Ó SQL Server Management Studio ÖØÐÂÆô¶¯ SQL Server 
ÔÚ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖУ¬ÓÒ¼üµ¥»÷ÄúµÄ·þÎñÆ÷£¬ÔÙµ¥»÷“ÖØÐÂÆô¶¯”¡£Èç¹ûÔËÐÐÓÐ SQL Server ´úÀí£¬ÔòÒ²±ØÐëÖØÐÂÆô¶¯¸Ã´úÀí¡£
 Ê¹Óà Transact-SQL ÆôÓà sa µÇ¼ÕÊ»§ 
Ö´ÐÐÏÂÁÐÓï¾äÒÔÆôÓà sa ÃÜÂë²¢·ÖÅäÒ»¸öÃÜÂë¡£
 ¸´ÖÆ´úÂë
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<password>' ;
GO
 Ê¹Óà Management Studio ÆôÓà sa µÇ¼ÕÊ»§ 
ÔÚ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖУ¬ÒÀ´ÎÕ¹¿ª“°²È«”¡¢“µÇ¼Ãû”£¬ÓÒ¼üµ¥»÷“sa”£¬ÔÙµ¥»÷“ÊôÐÔ”¡£
ÔÚ“³£¹æ”Ò³ÉÏ£¬Äú¿ÉÄÜÐèҪΪ sa µÇ¼Ãû´´½¨ÃÜÂ벢ȷÈϸÃÃÜÂë¡£
Ôړ״̬”Ò³µÄ“µÇ¼”²¿·ÖÖУ¬µ¥»÷“ÆôÓÔ£¬È»ºóµ¥»÷“È·¶¨”¡£
Section 2
ÒªÈÃdeveloper ¿ÉÒÔͨ¹ýnetwork login µ½SQL Server 2005¾ÍÒª½øÐÐÈçÏÂcofiguration¡£
Start Menu -> Microsoft SQL Server 2005 -> Configur


Ïà¹ØÎĵµ£º

SQL ¸½¼ÓÊý¾Ý¿âʱ³öÏÖ ÎÞ·¨´ò¿ªÎïÀíÎļþ´íÎó

SQL ¸½¼ÓÊý¾Ý¿âʱ³öÏÖ ÎÞ·¨´ò¿ªÎïÀíÎļþ´íÎó
´íÎóÐÅÏ¢:
Ö´ÐÐ Transact-SQL Óï¾ä»òÅú´¦Àíʱ·¢ÉúÁËÒì³£¡£ (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ÎÞ·¨´ò¿ªÎïÀíÎļþ "D:\SqlDataBase\Test.mdf"¡£²Ù×÷ϵͳ´íÎó 5:"5(¾Ü¾ø·ÃÎÊ¡£)"¡£ (Microsoft SQL Server£¬´íÎó: 5120)
½â¾ö°ì·¨:
  ......

SQL Serverµ¼Èëµ¼³öÊý¾Ý´óÈ«

SQLÓï¾äµ¼Èëµ¼³ö´óÈ«[ÊÕ¼¯]
ÕýÇÉÕâÁ½ÌìÒªÓõ½Õâ¸ö£¬ÉÏÍøÕÒµ½Ò»¸ö£¬»ØÀ´×Ô¼º¼ì²âһϣº
/******* µ¼³öµ½excel
EXEC master..xp_cmdshell 'bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -
S"GNETDATA/GNETDATA" -U"sa" -P""'
/*********** µ¼ÈëExcel
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
......

½«accessµ¼ÈëSQL server £¨×ª£©

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚ Transact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERV ......

Sql²Ù×÷´óÈ«

SQL²Ù×÷È«¼¯
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ 
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE) 
DML—Êý¾Ý²Ù×ÝÓïÑÔ(
SELECT£¬DELETE£¬UPDATE£¬INSERT) 
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£ ......

sql¾«Õ¿·ÖÒ³Óï¾ä

select top Ò³´óС *
from table1
where id>
      (select max (id) from
      (select top ((Ò³Âë-1)*Ò³´óС) id from table1 order by id) as T) order by id ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ