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

SQL ֪ʶ

--------------------------------²éѯϵͳ¿âÖÐÊÇ·ñÓп⣨Óпâ¾Íɾ³ý´Ë¿â£©----------------------------------------------------
use master
if exists(select * from databases where name='¿âÃû')
drop database ¿âÃû
__________________________  ½¨Êý¾Ý¿â½¨±íµÄ»ù±¾¸ñʽ  ___________________________________________
create database ¿âÃû
on primary
(name='student1',filename='·¾¶\student1.mdf',size=10mb, filegrowth=15%),                Ö÷Îļþ
(name='student2',filename='·¾¶\student2.ndf',size=10mb, filegrowth=15%)                 ´ËÎļþ
log on
(name='student1_log',filename='·¾¶\student1.ldf',size=1mb,filegrowth=15%,maxsize=300mb),   ÈÕÖ¾Îļþ
(name='student2_log',filename='·¾¶\student2.ldf',size=1mb,filegrowth=15%,maxsize=300mb)
go
use ¿âÃû
create table ±íÃû
(ÁÐÃû1 Êý¾ÝÀàÐÍ Ö÷¼ü ÊÇ·ñÔö³¤ Ψһ  Ä¬ÈÏ  ÊÇ·ñΪ¿Õ£¬
name varchar  primary key  identity(±íʾÖÖ×Ó£¬Ôö³¤Á¿) unique default  not null,
)
-------------------------½¨Êý¾Ý¿â±íÖ®¼äµÄÔ¼Êø-------------------------------------------------------
            alter table kk add
df ĬÈÏ       constraint  df_sex default(nan) for sex
pk Ö÷¼ü       constraint  pk_ÁÐÃû  primary key(ÁÐÃû)
ck ¼ì²é       constraint  ck_ÁÐÃû  check(len(ÁÐÃû)>=6)
              constraint  ck_ÁÐÃû  check(ÁÐÃû like [email='%@%']'%@%'[/email])
fk Ö÷Íâ¼ü     constraint  fk_Íâ¼üÁÐÃû foreign key(Íâ¼üÁÐÃû) references Ö÷±íÃû£¨Ö÷±íÁУ©
      
uq Ψһ  


Ïà¹ØÎĵµ£º

·ÀÖ¹SQL×¢Èë

×î½ü¿´µ½ºÜ¶àÈ˵ÄÍøÕ¾¶¼±»×¢Èëjs,±»iframeÖ®ÀàµÄ¡£·Ç³£¶à¡£
±¾ÈËÔø½ÓÊÖ¹ýÒ»¸ö±È½Ï´óµÄÍøÕ¾£¬±»È˼ÒÈëÇÖÁË£¬ÒªÎÒÊÕʰ²Ð¾Ö¡£¡£
1.Ê×ÏÈÎÒ»á¼ì²éһϷþÎñÆ÷ÅäÖã¬ÖØÐÂÅäÖÃÒ»´Î·þÎñÆ÷°²È«£¬¿ÉÒԲο¼
http://hi.baidu.com/zzxap/blog/item/18180000ff921516738b6564.html
2.Æä´Î£¬ÓÃÂó¿§·È×Ô¶¨Òå²ßÂÔ£¬¼´Ê¹ÍøÕ¾³ÌÐòÓЩ¶´ ......

ÈÃpowerdesignerÉú³ÉµÄsqlÔÚmysqlÏÂÕýÈ·ÔËÐÐ

Èç¹û°´ÕÕpowerdesignerµÄĬÈÏÑ¡Ïî,Éú³ÉµÄsql²»ÄÜÔÚmysqlÖÐÕýÈ·ÔËÐÐ.]
¾­¹ý±¾ÈËÑо¿·¢ÏÖÒª×öÈçÏÂÐÞ¸Ä:
  1.aftercreateÑ¡Ïî¸ÄΪ
.foreach_item(OutReferences)
   .ifnot (%hasFKIndex%)
/*==============================================================*/
/* Index: ......

JSPʵÏÖ¼òÒ×µÄSQL±¨±í

ÊäÈë: select ID as ±àºÅ, NAME as ÐÕÃû, AGE as ÄêÁä from XXX
Êä³ö:
񅧏
ÐÕÃû
ÄêÁä
 
 
 
ÒªÇóÊÇÈç¹ûSQL±ä¶¯, ÈÔȻҪÏÔʾ³öÀ´ËùÓеıðÃû×Ö¶ÎÐÅÏ¢ºÍÊý¾Ý.
ÒòΪÏÖÔÚHibernateÓõıȽϹ㷺, ËùÒÔÓÅÏÈ¿¼ÂÇÓÃHibernateÀ´ÊµÏÖ, ½á¹û·¢ÏÖÈç¹ûÊÇʵÌåÓ³Éä²éѯÓï¾ä, ¿ÉÒÔ·½±ãµÄÓÃ:List<String> Quer ......

mysql Ò»ÌõsqlÓï¾äupdate¸üÐÂÁ½¸ö±í

Äãд¹ýÒ»ÌõsqlÓï¾äÀ´ÐÞ¸ÄÁ½¸ö±íµÄÊý¾ÝÂð£¿
UPDATE test.table1 t1,test.table2 t2 SET t1.aa='a',t1.bb='b',t2.cc='c',WHERE t1.u_id=t2.u_id AND t1.u_id='1'  £»
table1µÄu_idºÍtable2µÄu_idÊÇÖ÷Íâ¼ü¹ØÏµ ......

sqlÃæÊÔÌâÄ¿

Sql³£ÓÃÓï·¨ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
 
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK) Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ