SQLSERVERÓû§È¨ÏÞ¹ÜÀíÊý¾Ý¿â
Óû§È¨ÏÞ¹ÜÀí
Ò»¡¢·þÎñÆ÷µÇ¼ÕʺźÍÓû§ÕʺŹÜÀí
1.SQL Server·þÎñÆ÷µÇ¼¹ÜÀí
²»¹ÜʹÓÃÄÄÖÖÈÏ֤ģʽ£¬Óû§¶¼±ØÐëÏȾ߱¸ÓÐЧµÄÓû§µÇ¼Õʺš£SQL ServerÓÐÈý¸öĬÈϵÄÓû§µÇ¼Õʺţº¼´sa¡¢Builtin\administratorsºÍguest¡£saÊÇϵͳ¹ÜÀíÔ±(system administrator)µÄ¼ò³Æ£¬ÊÇÒ»¸öÌØÊâµÄÓû§£¬ÔÚSQL ServerϵͳºÍËùÓÐÊý¾Ý¿âÖÐÓµÓÐËùÓеÄȨÏÞ¡£SQL Server»¹ÎªÃ¿Ò»¸öWindows NTϵͳ¹ÜÀíÔ±ÌṩÁËÒ»¸öĬÈϵÄÓû§ÕʺÅBuiltin\administrators¡£Õâ¸öÕʺÅÔÚϵͳºÍËùÓÐÊý¾Ý¿âÖÐÒ²ÓµÓÐËùÓеÄȨÏÞ¡£¶øguestÕʺÅΪĬÈÏ·ÃÎÊϵͳÓû§Õʺš£ÀûÓÃÆóÒµ¹ÜÀíÆ÷¿ÉÒÔ´´½¨¡¢¹ÜÀíSQL ServerµÇ¼Õʺš£Æä¾ßÌå²½ÖèÈçÏ£º
(1)´ò¿ªÆóÒµÆ÷£¬µ¥»÷·þÎñÆ÷µÄ“+”£¬Õ¹¿ª°²È«ÐÔÎļþ¼Ð£»
(2)ÓÒ»÷µÇ¼ͼ±ê£¬Ñ¡Ôñ“н¨µÇ¼”£»
(3)ÔÚ“Ãû³Æ”Îı¾¿òÖÐÊäÈëµÇ¼Ãû£¬Ñ¡Ôñн¨µÄÓû§ÕʺŵÄÈÏ֤ģʽ£»²¢Ñ¡ÔñĬÈϵÄÊý¾Ý¿âºÍÓïÑÔ¡£
(4)Ñ¡Ôñ“·þÎñÆ÷½ÇÉ«”£¬ÔÚÁгöµÄ¹Ì¶¨·þÎñÆ÷½ÇÉ«µÄ×ó¶Ë¸´Ñ¡¿òÖÐÑ¡ÔñÏàÓ¦µÄ·þÎñÆ÷½ÇÉ«£»
(5)Ñ¡Ôñ“Êý¾Ý¿â·ÃÎÊ”£¬µ¥»÷Êý¾Ý¿â×ó±ßµÄ¸´Ñ¡¿ò£¬±íʾ¸ÃÓû§¿ÉÒÔ·ÃÎÊÏàÓ¦µÄÊý¾Ý¿âÒÔ¼°¸ÃÕʺÅÔÚÊý¾Ý¿âÖеÄÓû§Ãû¡£Ï²¿µÄÁбí¿òÁгöÁËÏàÓ¦µÄÊý¾Ý¿âÖеÄÊý¾Ý¿â½ÇÉ«Çåµ¥£¬¿ÉÒÔÖ¸¶¨¸ÃÕʺÅËùÊôµÄÊý¾Ý¿â½ÇÉ«£»
(6)µ¥»÷“È·¶¨”¼´¿ÉÍê³ÉµÇ¼ÕʺŵĴ´½¨¡£
´ËÍ⣬»¹¿ÉÒÔʹÓô´½¨µÇ¼Ïòµ¼¹¤¾ß´´½¨µÇ¼Õʺš£¾ßÌå¹ý³ÌÈçÏ£º
(1)´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬Ñ¡Ôñ¹¤¾ßÖеēÏòµ¼--´´½¨µÇ¼Ïòµ¼”£»
(2)Ñ¡ÔñÉí·ÝÑé֤ģʽ£»
(3)
(4)
(5)
(6)
2.Óû§ÕʺŹÜÀí
ÔÚÊý¾Ý¿âÖУ¬Ò»¸öÓû§»ò¹¤×÷×éÈ¡µÃºÏ·¨µÄµÇ¼Õʺţ¬Ö»±íÃ÷¸ÃÕʺÅͨ¹ýÁËWindows NTÈÏÖ¤»òÕßSQL ServerÈÏÖ¤£¬µ«²»ÄܱíÃ÷Æä¿ÉÒÔ¶ÔÊý¾Ý¿âÊý¾ÝºÍÊý¾Ý¿â¶ÔÏó½øÐÐijÖÖ»òÕßijЩ²Ù×÷,scsi£¬Ö»Óе±ËûͬʱӵÓÐÁËÓû§Õʺź󣬲ÅÄܹ»·ÃÎÊÊý¾Ý¿â¡£ÔÚÒ»¸öÊý¾Ý¿âÖУ¬Óû§ÕʺÅΨһ±êʶһ¸öÓû§£¬Óû§¶ÔÊý¾Ý¿âµÄ·ÃÎÊȨÏÞÒÔ¼°¶ÔÊý¾Ý¿â¶ÔÏóµÄËùÓйØÏµ¶¼ÊÇͨ¹ýÕʺÅÀ´¿ØÖƵġ£Óû§ÕʺÅ×ÜÊÇ»ùÓÚÊý¾Ý¿âµÄ£¬¼´Á½¸ö²»Í¬µÄÊý¾Ý¿â¿ÉÒÔÓÐÁ½¸öÏàͬµÄÓû§Õʺţ¬²¢ÇÒÒ»¸öµÇ¼ÕʺÅÒ²×ÜÊÇÓëÒ»¸ö»ò¶à¸öÊý¾Ý¿âÓû§ÕʺÅÏà¶ÔÓ¦µÄ¡£È磬µÇ¼ÕʺÅsa×Ô¶¯Óëÿһ¸öÊý¾Ý¿âÓû§dboÏà¹ØÁª¡£Í¨³£¶øÑÔ£¬Êý¾Ý¿âÓû§ÕʺÅ×ÜÊÇÓëijһµÇ¼ÕʺÅÏà¹ØÁª£¬µ«ÓÐÒ»¸öÀýÍ⣬ÄǾÍÊÇguestÓû§¡£ÔÚ°²×°SQL Serverϵͳʱ£¬guestÓû§±»¼ÓÈëµ½master£¬pubs£¬tempdbºÍnorthwindÊý¾Ý¿âÖУ¬¸ÃÓû§Ö÷ÒªÊÇÈÃÄÇЩûÓÐÊôÓÚ×Ô¼ºµÄÓû§ÕʺÅ
Ïà¹ØÎĵµ£º
ÓÃoracleϰ¹ßÁË£¬µ¼³öÓÃexpÓï¾ä£¬Ö±½ÓÉú³ÉdmpÎļþ£¬µ¼ÈëÓÃimpÓï¾ä£¬±í½á¹¹ºÍÊý¾Ýͬʱ¸ã¶¨¡£×î½üÐèÒªÓõ½sqlserver£¬×ÜÊDz»Äܹ»Í¬Ê±µ¼³ö±í½á¹¹ºÍÊý¾Ý£¬googleÉϰٶÈÁ˺ܾÃҲû½â¾ö·½·¨¡£
ÓÒ¼ü--ËùÓÐÈÎÎñ--µ¼³öÊý¾Ý--Ñ¡ÔñÊý¾ÝÔ´£¬Êý¾ÝԴΪÓÃÓÚSQLServerµÄMicrosoft OLE DBÌṩ³ÌÐò£¬Ñ¡ÔñÑéÖ¤·½Ê½ ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create function [dbo].[split](@str nvarchar(1000),@word varchar(5),@no
int) returns nvarchar(500)
as begin
declare @len int
declare @index int
set @index=charindex(@word,@str)
  ......
1.oracle»·¾³
create table test
(
id number(4),
name varchar2(20)
)
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯû±»×èÈû
2.sqlserver»·¾³
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯ±»×èÈû(Ê ......