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 Ψһ
Ïà¹ØÎĵµ£º
Èç¹û°´ÕÕpowerdesignerµÄĬÈÏÑ¡Ïî,Éú³ÉµÄsql²»ÄÜÔÚmysqlÖÐÕýÈ·ÔËÐÐ.]
¾¹ý±¾ÈËÑо¿·¢ÏÖÒª×öÈçÏÂÐÞ¸Ä:
1.aftercreateÑ¡Ïî¸ÄΪ
.foreach_item(OutReferences)
.ifnot (%hasFKIndex%)
/*==============================================================*/
/* Index: ......
CREATE proc page
@RecordCount int output,
@QueryStr nvarchar(100)='table1',--±íÃû¡¢ÊÓͼÃû¡¢²éѯÓï¾ä
@PageSize int=20, --ÿҳµÄ´óС(ÐÐÊý)
@PageCurrent int=2, --ÒªÏÔʾµÄÒ³ ´Ó0¿ªÊ¼
@FdShow nvarchar (1000)='*', --ÒªÏÔʾµÄ×Ö¶ÎÁбí
@IdentityStr nvarchar (100)='id', --Ö÷¼ü
@WhereStr nvarchar ......
ÊäÈë: select ID as ±àºÅ, NAME as ÐÕÃû, AGE as ÄêÁä from XXX
Êä³ö:
񅧏
ÐÕÃû
ÄêÁä
ÒªÇóÊÇÈç¹ûSQL±ä¶¯, ÈÔȻҪÏÔʾ³öÀ´ËùÓеıðÃû×Ö¶ÎÐÅÏ¢ºÍÊý¾Ý.
ÒòΪÏÖÔÚHibernateÓõıȽϹ㷺, ËùÒÔÓÅÏÈ¿¼ÂÇÓÃHibernateÀ´ÊµÏÖ, ½á¹û·¢ÏÖÈç¹ûÊÇʵÌåÓ³Éä²éѯÓï¾ä, ¿ÉÒÔ·½±ãµÄÓÃ:List<String> Quer ......
Äãд¹ýÒ»Ìõ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ÊÇÖ÷Íâ¼ü¹ØÏµ ......
http://tech.163.com/05/0701/10/1NIODMQS00091589.html
ÒòΪÔÚPL/SQL Öв¢Ã»ÓÐÊý×é.
ÕâÊÇż²é×ÊÁÏÕҵķ¶ÀýºÍ×Ô¼ºÐ´µÄ·¶ÀýÀ´½âÊÍÈçºÎÔÚPL/SQL ÖÐʹÓÃÊý×é. Ò²ÐíºÜ¶àÈËÒÑÖªµÀ, ²»¹ý¾ÍÊÇÈò»ÖªµÀµÄÅóÓÑÃÇÁ˽âһϰɡ£
----------------------
µ¥Î¬Êý×é
------------------------
DECLARE
TYPE
emp_ssn_array IS TA ......