Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÎÒÔÚ±±´óÇàÄñËùѧSQL֪ʶµÄС»ã×Ü

´´½¨Îļþ¼Ð£ºexec xp_cmdshell 'md ÅÌ·û:\Îļþ¼ÐÃû³Æ', no_output
ÀýÈ磺ÔÚDÅÌ´´½¨ÃûΪ£º“×ÊÁÏ”µÄÎļþ¼Ð£ºexec xp_cmdshell 'md d:\×ÊÁÏ', no_output
 
²é¿´Îļþ£ºexec xp_cmdshell 'dirÅÌ·û:\Îļþ¼ÐÃû³Æ'¡£ÀýÈ磺exec xp_cmdshell 'dir d:\×ÊÁÏ'
ÅжÏÊý¾Ý¿âÊÇ·ñ´æÔÚ£ºif exists(select * from sysdatabases where name='Êý¾Ý¿âÃû³Æ')
drop database Êý¾Ý¿âÃû³Æ
 
ÅжϱíÊÇ·ñ´æÔÚ——if exists(select * from sysobjects where name='±íÃû')   drop table ±íÃû
 
Ìí¼ÓÔ¼Êø£¨5ÖÖ£©——Óï·¨£ºalter table ±íÃû add constraint Ô¼ÊøÃûÔ¼ÊøÀàÐÍ ¾ßÌåµÄÔ¼ÊøËµÃ÷
1.Ö÷¼üÔ¼Êø£ºalter table ±íÃû add constraint pk_Ô¼ÊøÃû primary key(Ö÷¼üÔ¼Êø×Ö¶ÎÃû)
2.Íâ¼ü£ºalter table±íÃûadd constraint fk_Ô¼ÊøÃûforeign key(Íâ¼ü×Ö¶ÎÃû) references ¹ØÏµ±í(Ö÷¼üÃû)
3.Î¨Ò»Ô¼Êø£ºalter table ±íÃû add constraint uq_Ô¼ÊøÃû unique (Î¨Ò»Ô¼Êø×Ö¶ÎÃû)
4.¼ì²éÔ¼Êø£ºalter table ±íÃû add constraint ck_Ô¼ÊøÃû check (Ô¼Êø¼ì²é×Ö¶ÎÃû)   --±í´ïʽ
5.ĬÈÏÔ¼Êø£ºalter table ±íÃû add constraint df_Ô¼ÊøÃû default (ĬÈÏÖµ) for ĬÈÏÔ¼Êø×Ö¶ÎÃû
 
ɾ³ýÔ¼ÊøÓï·¨£ºalter table ±íÃû drop constraint Ô¼ÊøÃû
ÀýÈ磺ɾ³ýstuInfo±íÖеØÖ·µÄĬÈÏÔ¼Êø£ºalter table stuInfo drop constraint Ô¼ÊøÃû(df_stuAddress)
 
µÚÒ»µÀ´óÃÅ——´´½¨µÇ¼ÕÊ»§£¨2ÖÖ£©
µÚÒ»ÖÖ£ºSQLÕË»§£ºexec sp_addlogin 'Óû§Ãû','ÃÜÂë'
µÚ¶þÖÖ£ºWindowsÕË»§£ºexec sp_grantlogin 'windowsÓòÃû\ÓòÕË»§'
µÚ¶þµÀ´óÃÅ——´´½¨Êý¾Ý¿âÓû§ £ºexec sp_grantdbaccess 'µÇ¼ÕË»§','Êý¾Ý¿âÓû§' 
--“Êý¾Ý¿âÓû§”Ϊ¿ÉÑ¡²ÎÊý£¬Ä¬ÈÏΪµÇ¼ÕË»§£¬¼´Êý¾Ý¿âÓû§Ä¬ÈϺ͵ǼÕË»§Í¬Ãû¡£
ÀýÈ磺ÔÚÊý¾Ý¿âÖÐÌí¼ÓÒ»¸öÓû§£º
exec sp_grantdbaccess 'zhang','zhangUser'     --'zhangΪµÇ¼ÕË»§','zhangUserΪÊý¾Ý¿âÓû§'
 
µÚÈýµÀ´óÃÅ——ÏòÊý¾Ý¿âÓû§ÊÚȨ£ºgrant ȨÏÞ on ±íÃû to Êý¾Ý¿âÓû§
ÀýÈ磺ΪzhangsanUserÊÚÓè¶Ô±ístuInfoµÄÔöɾ¸Ã²éµÄȨÏÞ
grant select,update,delete,insert on stuInfo to zhangsanUser
½¨±íµÄȨÏÞ£ºgrant create table to zhangsanUser
 
----------------------------------µÚÈýÕ T—SQL±à³Ì--------


Ïà¹ØÎĵµ£º

SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......

SQL SERVER¶àÁÐÈ¡×î´ó»òÕß×îСֵ

/*
lvl1  lvl2    lvl3    lvl4    lvl
4      3      4      1       
3      2      2&nb ......

ÈçºÎ·ÀÖ¹SQL×¢Èë¹¥»÷

BSϵͳÖУ¬´«Í³µÄ×¢Èë¹¥»÷ÊÖ¶ÎÓкܶࡣ
×î»ù±¾µÄ£¬ÀûÓõ¥ÒýºÅ¹¥»÷µÄ£¬ºÜÈÝÒ×½â¾ö£¬ÓÃÀàËÆÓÚQuotedStr()£¨Êµ¼Ê¿ª·¢ÊÇÆäËûÓïÑÔ£¬ÕâÀïÓÃDELPHIÖеĺ¯Êý´úÌæ£©µÄº¯Êý´¦Àí²ÎÊý¼´¿É¡£
µ«Êµ¼ÊÓ¦ÓÃÖУ¬²»¿É±ÜÃâ»áÓÐһЩӦÓÃÐèÒªÖ±½Ó´«µÝ²ÎÊý£¬ÀýÈç±íÃû¡¢²éѯÌõ¼þ¡¢ÅÅÐòÌõ¼þµÈµÈ
¶ÔÕâЩӦÓõÄ×¢Èë¹¥»÷·À²»Ê¤·À¡£
ÎÒ¿¼ÂÇÁËÒ»¸ ......

PL/SQL¿éÖÐÈçºÎµ÷ÓÃDDLÓï¾ä

ÔÚPL/SQL¿éÖв»ÄÜÖ±½Óµ÷ÓÃDDLÓï¾ä£¬¿ÉÒÔÀûÓÃÏÂÃæµÄ·½·¨½øÐе÷ÓÃ
·½·¨Ò»£º¶¯Ì¬SQL
execute immediate 'CREATE TABLE newtable AS
                             &nb ......

ÎÒÔÚ±±´óÇàÄñËùѧSQL֪ʶµÄС»ã×Ü

´´½¨Ò»¸öÊý¾Ý¿â£¨¿âÃû£ºÑ§Éú¿â£©²¢ÉèÖÃÁ½¸öÊý¾ÝÎļþºÍÁ½¸öÈÕÖ¾Îļþ
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=ѧÉú_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ