【正文】 from View_relation_information 通過會(huì)員編號(hào)，使用存儲(chǔ)過程查詢 Declare aid int set aid=1 Execute Up_relation_information aid [史 ]： 創(chuàng)建會(huì)員登錄視圖 /*==============================================================*/ /* View: Vi。, As 39。, qq AS 39。 from View_job_information where aid=aid 通過會(huì)員編號(hào)，使用存儲(chǔ)過程查詢 Declare aid int set aid=1 Execute Up_job_information aid 創(chuàng)建基于聯(lián)系信息視圖的存儲(chǔ)過程，當(dāng)用戶拿到 aid后，選擇聯(lián)系信息進(jìn)行進(jìn)一步的查詢 Create Procedure Up_relation_information aid int As select phone As 39。, workadd As 39。, appellation As 39。, profession As 39。 , unitquality As 39。 from View_edu_information where aid=aid 通過會(huì)員編號(hào)，使用存儲(chǔ)過程查詢 Declare aid int set aid=1 Execute Up_edu_information aid 創(chuàng)建基于工作信息視圖的存儲(chǔ)過程，當(dāng)用戶拿到 aid后，選擇工作信息進(jìn)行進(jìn)一步的查詢 Create Procedure Up_job_information aid int As select workunit As 39。, college As 39。 from View_family_information where aid=aid 通過會(huì)員編號(hào)，使用存儲(chǔ)過程查詢信息 Declare aid int set aid=1 Execute Up_family_information aid 創(chuàng)建基于學(xué)歷信息視圖的存儲(chǔ)過程， 當(dāng)用戶拿到 aid后，選擇學(xué)歷信息進(jìn)行進(jìn)一步的查詢 Create Procedure Up_edu_information aid int As select major As 39。, carstate As 39。, housestate As 39。 from View_personal_information where aid=aid 使用存儲(chǔ)過程查詢數(shù)據(jù) Declare aid int set aid=1 Execute Up_personal_information aid 創(chuàng)建基于家庭信息視圖的存儲(chǔ)過程，當(dāng)用戶拿到 aid后，選擇家庭信息進(jìn)行進(jìn)一步的查詢 Create Procedure Up_family_information aid int As select familymembers As 39。, healthstate As 39。, bodytape As 39。, weight As 39。 set inemonth=0 Execute Up_important_information sex, age, edubackground, inemonth 創(chuàng)建基于個(gè)人信息視圖的存儲(chǔ)過程，當(dāng)用戶拿到 aid后，選擇個(gè)人信息進(jìn)行進(jìn)一步的查詢 Create Procedure Up_personal_information aid int As select height As 39。 from View_VectorQuery where sex=sex and age=age and edubackground=edubackground and inemonth=inemonth 使用存儲(chǔ)過程查詢數(shù)據(jù) declare sex bit declare age int declare edubackground varchar(6) declare inemonth int set sex=1 set age=21 set edubackground=39。, inemonth As 39。, edubackground As 39。, age As 39。 下面是基于數(shù)據(jù)庫操作的事務(wù)創(chuàng)建的存儲(chǔ)過程 使用泛查詢視圖，創(chuàng)建存儲(chǔ)過程 創(chuàng)建存儲(chǔ)過程，當(dāng)用戶輸入四個(gè)查詢條件時(shí)，為用戶返回符合條件的查詢結(jié)果 Create Procedure Up_important_information sex bit,age int,edubackground varchar(6),inemonth int as select sex As 39。*[^.][^.]*.*39。*[^.][^.]*.*39。\d{5,10}39。1[385][2356789]\d{8}39。1[3,8,5][2,3,5,6,7,8,9][09][09][09][09][09][09][09][09]39。未婚 39。未婚 39。\d{17}[xX]39。\d{15}39。漢族 39。雙魚座 39。水瓶座 39。摩羯座 39。射手座 39。天蝎座 39。天秤座 39。處女座 39。獅子座 39。巨蟹座 39。雙子座 39。金牛座 39。白羊座 39。豬 39。狗 39。雞 39。猴 39。羊 39。馬 39。蛇 39。龍 39。兔 39。虎 39。牛 39。鼠 39。) /* 設(shè)置 ，年齡不用會(huì)員輸入，通過生日和當(dāng)前的年份通過計(jì)算得到 。 or sex=39。 For sex Alter Table Associators With Check Add Constraint CH_Associators_sex Check(sex=39。 */ Alter Table Associators Add Constraint DF_Associators_sex Default 39。且只能為 39。 go /*==============================================================*/ /* Index: JoinFethersInformations_FethersInfromations_FK */ /*==============================================================*/ create index JoinFethersInformations_FethersInfromations_FK on JoinFethersInformations ( fid ASC ) go /*==============================================================*/ /* Index: JoinFethersInformations_Associators_FK */ /*==============================================================*/ create index JoinFethersInformations_Associators_FK on JoinFethersInformations ( aid ASC ) go /*==============================================================*/ /* Table: TrystInformations */ /*==============================================================*/ create table TrystInformations ( tid int not null, aid int not null, taddress varchar(20) not null, ttime datetime not null, tadvancedid varchar(18) not null, ttype varchar(6) not null, disposalstate varchar(6) not null, constraint PK_TRYSTINFORMATIONS primary key nonclustered (tid) ) go /*==============================================================*/ /* Index: Associators_TrystInformations_FK */ /*==============================================================*/ create index Associators_TrystInformations_FK on TrystInformations ( aid ASC ) go /* 為 */ /* 為 ，設(shè)置性別默認(rèn)為 39。, 39。, CurrentUser, 39。, 39。, 39。 go /*==============================================================*/ /* Table: JoinFethersInformations */ /*==============================================================*/ create table JoinFethersInformations ( aid int not null, fid int not null, remark varchar(20) null ) go declare CurrentUser sysname select CurrentUser = user_name() execute s