ÎÒÔÚ±±´óÇàÄñËùѧ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µÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ czdImport Dat ......
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
Ò»¡¢°´Ö¸¶¨·ûºÅ·Ö¸î×Ö·û´®£¬·µ»Ø·Ö¸îºóµÄÔªËØ¸öÊý£¬·½·¨ºÜ¼òµ¥£¬¾ÍÊÇ¿´×Ö·û´®ÖдæÔÚ¶àÉÙ¸ö·Ö¸ô·ûºÅ£¬È»ºóÔÙ¼ÓÒ»£¬¾ÍÊÇÒªÇóµÄ½á¹û¡£
CREATE function Get_StrArrayLength
(
@str varchar(1024), --Òª·Ö¸îµÄ×Ö·û´®
@split varchar(10) --·Ö¸ô·û ......
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“”¿Î³Ì±È“”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
SELECT a.S# from (SELECT s#,score from SC WHERE C#='001') a,
(SELECT s#,score ......
---- ÈËÃÇÔÚʹÓÃSQLʱÍùÍù»áÏÝÈëÒ»¸öÎóÇø£¬¼´Ì«¹Ø×¢ÓÚËùµÃµÄ½á¹ûÊÇ·ñÕýÈ·£¬¶øºöÂÔ
Á˲»Í¬µÄʵÏÖ·½·¨Ö®¼ä¿ÉÄÜ´æÔÚµÄÐÔÄܲîÒ죬ÕâÖÖÐÔÄܲîÒìÔÚ´óÐ͵ĻòÊǸ´ÔÓµÄÊý¾Ý¿â
»·¾³ÖУ¨ÈçÁª»úÊÂÎñ´¦ÀíOLTP»ò¾ö²ßÖ§³ÖϵͳDSS£©ÖбíÏÖµÃÓÈΪÃ÷ÏÔ¡£±ÊÕßÔÚ¹¤×÷ʵ¼ù
Öз¢ÏÖ£ ......