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

sql×ܽá

1.´´½¨Êý¾Ý¿â
    --exec xp_cmdshell 'mkdir d:\project'--µ÷ÓÃDOSÃüÁî´´½¨Îļþ¼Ð£¬Ê¹Óô˾äÐèÒªÆô¶¯SQLµÄÍâΧ¹¤¾ß
    if exists(select * from sysdatabases where name='Êý¾Ý¿âÃû')
     drop database Êý¾Ý¿âÃû
    set nocount on   --È¡ÏûÊÜÓ°ÏìÐÐÊý
    create database Êý¾Ý¿âÃû
    on
    (
     name='',
     filename='',--  .mdf .ldf
     size=10mb,
     maxsize=
     filename=    --Êý¾Ý¿â´óСÔö³¤Á¿
    )
    log on
    (
    )
    go
    use Êý¾Ý¿âÃû
--´´½¨µÇ¼Óû§
exec sp_addlogin 'Óû§Ãû','ÃÜÂë'
--È¥µôÊÜÓ°ÏìÐÐÊý
set nocount on
exec sp_grantdbaccess 'adminMaster','adminMaster'
--ÉèÖÃÓû§¶Ô±íµÄȨÏÞ
grant select,delete,update on bbstopic to Óû§Ãû
2.´´½¨±í¼°Ìí¼ÓÔ¼Êø
    create table ±í
    (
    )
    alter table ±í add
    constraint Ô¼ÊøÃû primary key(ÁÐÃû)  --Ö÷¼üÔ¼Êø  identity
    constraint Ô¼ÊøÃû check(len(ÁÐÃû))  --checkÔ¼Êø
    constraint Ô¼ÊøÃû unique(ÁÐÃû) --Î¨Ò»Ô¼Êø
    constraint Ô¼ÊøÃû default(ĬÈÏÄÚÈÝ) for ÁÐÃû
    constraint Ô¼ÊøÃû foreign key(Íâ¼üÃû)
    references Ö÷¼üÊý¾Ý¿âÃû(Ö÷¼üÃû)
    ck£ºcheckÔ¼Êø
    fk£ºÍâ¼üÔ¼Êø
    df£ºdefaultĬÈÏ
  ×¢£ºalter ¸Ä±ä, ¸ü¸Ä
    add ¼ÓÈ룬 Ôö¼Ó, Ìí¼Ó
    constraint Ç¿ÖÆ£¬ÏÞÖÆ, Ô¼Êø
    foreign key Íâ¼ü
    references ÒýÓÃ
          
3.sqlÖеĹؼü×Ö£º
    sysdatabases ×Ü¿â
    exists  ÅжÏÊÇ·ñ´æÔÚ


Ïà¹ØÎĵµ£º

[ÊÕ£] ÓÃsqlite Ö´Ðбê×¼ sql Óï·¨

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 ......

sql checkÔ¼Êø

CHECK Ô¼Êø(CHECK Ô¼Êø:¶¨ÒåÁÐÖпɽÓÊܵÄÊý¾ÝÖµ¡£¿ÉÒÔ½« CHECK Ô¼ÊøÓ¦ÓÃÓÚ¶à¸öÁУ¬Ò²¿ÉÒÔ½«¶à¸ö CHECK Ô¼ÊøÓ¦ÓÃÓÚµ¥¸öÁС£µ±³ýȥij¸ö±íʱ£¬Ò²½«³ýÈ¥ CHECK Ô¼Êø¡£)Ö¸¶¨¿ÉÓɱíÖÐÒ»Áлò¶àÁнÓÊܵÄÊý¾ÝÖµ»ò¸ñʽ¡£ÀýÈ磬¿ÉÒÔÒªÇó authors ±íµÄ zip ÁÐÖ»ÔÊÐíÊäÈëÎåλÊýµÄÊý×ÖÏî¡£
¡¡¡¡
¡¡¡¡¿ÉÒÔΪһ¸ö±í¶¨ÒåÐí¶à CHECK Ô¼Êø¡£¿ ......

EXCELÊý¾Ýµ¼ÈëSQL µÄÁíÀàÓ÷¨

×ö¿ª·¢¹ý³ÌÖУ¬¾­³£»áÓõ½½«ExcelÖÐÊý¾Ýµ¼³öµ½SQL ServerÖеÄÇé¿ö£¬Äã¿ÉÒÔÀûÓÃSQL SERVER ÖÐ×Ô´øµÄµ¼ÈëÊý¾ÝµÄ·½Ê½£¬µ«ÕâÖÖ·½Ê½£¬ÓÐʱ»á·¢ÏÖÊý¾Ýµ¼Èëºó£¬¿ÉÄÜΪ¿Õ£¬¿ÉÄÜ¿ªÍ·ÉÙ¸öÁ㣬´ËÖÖÇé¿ö¶à³öÏÖÓÚÊýÖµÐ͵ÄÁУ¬½ñÌìÔÚCSDNÉÏÏй䣬ż¶û·¢ÏÖÁËÒ»¸öÌû×Ó£¬½éÉܵÄÒÔÏÂÕâÖÖ·½·¨£¬±¾ÈËÇ¡ÆßÒò×î½ü¹«Ë¾×¼±¸ÉÏÊУ¬É󼯾ÖÔÚ×öÉ󼯣¬¼¼ ......

SQL Êý¾Ý¿âÖ®Ò»

1.      SELECT
ʵÀý105
SELECT ID "±àºÅ",Name ÐÕÃû,
       Math_Score 'Êýѧ³É¼¨',  //ÔõôÓеÄÓÐAS,ÓеÄûÓÐ
       Music_Score AS ÒôÀֳɼ¨,
       English_Score AS Ó¢Îijɼ¨
f ......

SQLÊý¾Ý¿â

l  ÔÚ³ÌÐòÖÐÆ´½ÓSQLÃüÁî
¿ÉÊÇÈçºÎÔÚC#³ÌÐòÖÐÔËÐÐÄØ£¿ÎÒÃǼǵÃÔÚÆÕͨµÄSQL²éѯÖУ¬Ò»°ãÐèÒª°Ñ²éѯÓï¾ä¸³Öµ¸øSalCommand.CommandTextÊôÐÔ£¬ÕâÀïÒ²¾ÍÏñÆÕͨµÄSQL²éѯÓï¾äÒ»Ñù£¬½«ÕâЩÓï¾ä¸³¸øSqlCommand.CommandTextÊôÐÔ¼´¿É¡£Òª×¢ÒâµÄÒ»µãÊÇ£¬ÆäÖеÄ"GO"Óï¾ä±êÖ¾×ÅSQLÅú´¦ÀíµÄ½áÊø£¬±àдSQL½Å±¾ÊÇÐèÒªµÄ£¬µ«ÊÇÔÚÕâÀïÊDz ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ