һЩ¼òµ¥µÄ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
Ïà¹ØÎĵµ£º
##################################################
# ÉùÃ÷£º
# ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
# ÔÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/05/13/5588454.aspx
####### ......
##################################################
# ÉùÃ÷£º
# ±¾ÎÄת×ÔCSDN£¬Óû§ID£ºhtl258
# ÔÌûµØÖ·£ºhttp://blog.csdn.net/htl258/archive/2010/04/28/5537432.aspx
####### ......
ÏÂÔصØÖ·£ºhttp://download.csdn.net/source/2384982
----------------------------------------------------------------------------
Èí¼þÃû³Æ£ºÍ¨ÓÃSql±¸·Ý»Ö¸´¹¤¾ß
Ö´ÐгÌÐò£ºiNethink_SqlTool.exe
³ÌÐò°æ±¾£ºV1.0.0.1
----------------------------------------------------------------------------
Md5Öµ:E511 ......
˼·:SQLÀᄀ¿ÉÄܵIJÉÓÃÁ½¸öÒýºÅ±ÕºÏ±äÁ¿;¶Ô±äÁ¿ÖеÄÒýºÅתÒå;¶Ô²»ÄܲÉÓÃ2¸öÒýºÅ±ÕºÏµÄ±äÁ¿,ÏÈÔ¤ÏÈÅжϱäÁ¿ÀàÐÍ;
·½°¸:
1 ËùÓзÇÊýÖµÔËËã(Èç×Ö·û,¼òµ¥ÊýÖµÐ͵ȵÈ)µÄSQL±äÁ¿¶¼¼ÓÒýºÅ;
2 ËùÓзÇÊýÖµÔËËãµÄSQL±äÁ¿µÄÖµ¶¼²ÉÓÃmagic_quotes_gpc» ......
×°sql 2005ºó¶ÔһЩ¹¦ÄÜ»¹²»ÊǺÜÏ°¹ß£¬±ÈÈçÓÃsaµÇ¼Êý¾Ý¿âÔںܶàµØ·½¶¼»áÓõ½£¬½ñÌì¾ÍsaµÇ¼Êý¾Ý¿âµÄһЩÐÞ¸ÄÓë´ó¼Ò·ÖÏí¡£
1.ÏÈÓÃWINDOWSģʽµÇ½,È»ºóÔÚÊý¾Ý¿â¶¥¶ËÓÒ¼üÊôÐÔ£»Èçͼ1-1£º
2.ÔÚ°²È«ÐÔϵÄWINDOWSģʽ¸ÄΪSQLÓëWINDOWSģʽ£¬ÏÂÃæµÄµÇ½ÉóºËÑ¡Ïî,Ñ¡ÔñΪ‘ÎÞ’£¬µã‘È·¶¨’£»Èçͼ1-2£º
3. ......