´´½¨Ò»¸öÊý¾Ý¿â£¨¿âÃû£ºÑ§Éú¿â£©²¢ÉèÖÃÁ½¸öÊý¾ÝÎļþºÍÁ½¸öÈÕÖ¾Îļþ
create database ѧÉú¿â
on primary
( name=ѧÉú_data1, filename='e:\ѧÉú_data1.mdf', size=1mb, maxsize=3mb,filegrowth=1mb ),
( name=ѧÉú_data2, filename='e:\ѧÉú_data2.ndf', size=1mb, maxsize=3mb, filegrowth=10% )
log on
( name=ѧÉú_log1, filename='e:\ѧÉú_log1.ldf', size=1mb, maxsize=2mb, filegrowth=1mb ),
( name=ѧÉú_log2, filename='e:\ѧÉú_log2.ldf', size=1mb, maxsize=2mb, filegrowth=10% )
ɾ³ýÊý¾Ý¿â£ºdrop database ѧÉú¿â£¨Êý¾Ý¿âÃû£©
¸ü¸ÄÊý¾Ý¿âÖУ¨Êý¾ÝÎļþѧÉú_data1£©µÄÔʼ´óС½á¹¹
alter database ѧÉú¿â modify file ( name=ѧÉú_data1,size=5mb )
¸ü¸ÄÊý¾Ý¿âÖУ¨ÈÕÖ¾ÎļþѧÉú_log1£©µÄÔʼ´óС½á¹¹
alter database ѧÉú¿â modify file ( name=ѧÉú_log1,size=2mb )
ΪÊý¾Ý¿âÌí¼ÓÒ»¸öÈÕÖ¾Îļþ£¨Ñ§Éú_log3£©
alter database ѧÉú¿â
add file( name=ѧÉú_log3, filename='e:\ѧÉú_log3.ldf', size=1mb£¬maxsize=2mb, filegrowth=10% )
ÉèÖÃÊý¾Ý¿â£¨Ñ§Éú¿â£©ÎªÖ»¶Á£ºexec sp_dboption 'ѧÉú¿â','read only',true
ÉèÖÃÔÚͬһʱ¼äÄÚÖ»ÓÐÒ»¸öÓû§·ÃÎÊÊý¾Ý¿â£¨Ñ§Éú¿â£©£ºexec sp_dboption 'ѧÉú¿â','single user'
×Ô¶¨ÒåÊý¾ÝÀàÐÍ£ºexec sp_addtype city£¨ÀàÐÍÃû£© ,'nvarchar(15)',null
ɾ³ý×Ô¶¨ÒåÊý¾ÝÀàÐÍ£ºexec sp_droptype city£¨ÀàÐÍÃû£©
use ѧÉú¿â ´ò¿ªÊý¾Ý¿â£¨Ñ§Éú¿â£©
create table ѧÉú±í£¨±íÃû£© ´´½¨Ò»¸öѧÉú±í
( ѧºÅ int not null, ÐÕÃû varchar(20), °®ºÃ varchar(20), ³öÉúÈÕÆÚ datetime)
ɾ³ý±í£ºdrop table ѧÉú±í£¨±íÃû£©
±êʶԼÊøÊôÐÔ£¨Á½ÖÖ·½·¨£©£º
¢ÙÔÚ´´½¨±í£¨Ñ§Éú±í£©µÄͬʱ£¬½«Ñ§ºÅÉèÖñêʶ
create table ѧÉú±í
(ѧºÅint not null identity(1,1)primary key,ÐÕÃûvarchar(20)unique,°®ºÃvarchar(20),³öÉúÈÕÆÚ datetime)
¢Ú¸ü¸ÄѧÉú±í£¬Ìí¼ÓѧºÅ±êʶ
create table ѧÉú±í(ÐÕÃû varchar(20) unique,°®ºÃ varchar(20),³öÉúÈÕÆÚ datetime)
alter table ѧÉú±í add ѧºÅ£¨×Ö¶ÎÃû£© int identity(1,1)
Ö÷¼üÔ¼Êø£¨Á½ÖÖ·½·¨£©£º
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......