һЩ¼òµ¥µÄSQLÓï¾ä×ܼÆ

--------¼ì²âÊý¾Ý¿âÊÇ·ñ´æÔÚ
use master
go
if exists(select * from sysdatabases where name='DBName')
drop database DBName
-----´´½¨Êý¾Ý¿â
create database DBName
on
(
 /*Êý¾ÝÎļþµÄ¾ßÌåÃèÊö*/
 name='DBName_data', -----Ö÷Êý¾ÝÎļþµÄÂß¼­Ãû³Æ
 filename='D:\project\DBName_data.mdf',   --Ö÷Êý¾ÝÎļþµÄÎïÀíÃû³Æ
 size=5mb,   --Ö÷Êý¾ÝÎļþµÄ³õʼ´óС
 maxsize=100mb,   --Ö÷Êý¾ÝÎļþµÄ×î´óÖµ
 filegrowth=15%  --Ö÷Êý¾ÝÎļþµÄÔö³¤ÂÊ
)
log on
(
 /*ÈÕÖ¾ÎļþµÄ¾ßÌåÃèÊö£¬¸÷²ÎÊýº¬ÒåͬÉÏ*/
 name='DBName_log',
 filename='D:\project\DBName_data.mdf',
 size=2mb,
 filegrowth=1mb
)
go
------------ɾ³ýÊý¾Ý¿â
drop database DBName
--------¼ì²â±íÊÇ·ñ´æÔÚ
use DBName
go
if exists(select * from sysobjects where name='tableName')
drop table tableName
-------´´½¨±í
use DBName
go
create table tableName
(
 clName int identity(1,1) not null,  ---±êʶÁУ¬×Ô¶¯Ôö³¤
 clName2 varchar(50) not null
)
go
--------ɾ³ý±í
drop table tableName
------´´½¨Ô¼Êø
alter table tableName add
constraint PK_clName primary key(clName),     ---Ö÷¼üÔ¼Êø
constraint UQ_clName unique (clName),    ----ΨһԼÊø
constraint CK_clName check(clName between 0 and 100),     ---¼ì²éÔ¼Êø
constraint DF_clName default(100) for clName,     ----ĬÈÏÔ¼Êø
constraint FK_clName foreign key(clName) references tbName(clName)   ---Íâ¼üÔ¼Êø£¬ºóÃæÊÇÖ÷±íÖ÷¼ü
----------ɾ³ýÔ¼Êø
alter table tableName
 drop constraint PK_clName
-------Ìí¼ÓWindowsµÇ½ÕË»§
exec sp_grantlogin 'jbtraining\s26301' -----------jbtraining±íʾÓò£¬s26301±íʾÓòÕË»§
-------Ìí¼ÓSQLµÇ¼ÕË»§
exec sp_addlogin 'zhangsan','1234'  -----------ÕË»§ÃûΪzhangsan,ÃÜÂëΪ1234
-------´´½¨Êý¾Ý¿âÓû§
exec sp_grantdbaccess 'zhangsan'    ---------µÇ¼ÕË»§Îªzhangsan,Êý¾Ý¿âÓû§Ä¬ÈϺ͵ǼÕË»§Í¬Ãû
------ΪÊý¾Ý¿âÓû§ÊÚȨ
grant select,insert,update