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 ¸½¼ÓÊý¾Ý¿âʱ³öÏÖ ÎÞ·¨´ò¿ªÎïÀíÎļþ´íÎó
´íÎóÐÅÏ¢:
Ö´ÐÐ Transact-SQL Óï¾ä»òÅú´¦Àíʱ·¢ÉúÁËÒì³£¡£ (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ÎÞ·¨´ò¿ªÎïÀíÎļþ "D:\SqlDataBase\Test.mdf"¡£²Ù×÷ϵͳ´íÎó 5:"5(¾Ü¾ø·ÃÎÊ¡£)"¡£ (Microsoft SQL Server£¬´íÎó: 5120)
½â¾ö°ì·¨:
......
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',
......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚ Transact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERV ......
SQL²Ù×÷È«¼¯
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(
SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£ ......
select top Ò³´óС *
from table1
where id>
(select max (id) from
(select top ((Ò³Âë-1)*Ò³´óС) id from table1 order by id) as T) order by id ......