數(shù)據(jù)庫技術(shù)與應(yīng)用-sqlserver20xx劉衛(wèi)國熊擁軍主編課后習(xí)題答案-全文預(yù)覽
【正文】 VALUES(Order_id1,goods_id,employee_id,Custom_ID,Transporter_ID,order_date) SELECT order_id2=Order_ID1 FROM sell_order WHERE Order_ID1=Order_id1 ENDDECLARE order_id2 char(6)EXEC prStoreOrderID 39。 when 4 then 39。 end as 年齡段,department_name as 所屬部門from department,employee where = order by 所屬部門 ascselect nld as 年齡段,count(*) as 人數(shù) from (select case (datediff(yy,birth_date,getdate())1)/10 when 2 then 39。 when 4 then 39。 END AS 商品類別, unit_price AS 單價(jià),stock_quantity as 庫存FROM goodsdeclare value realset value=1while value2begin select sign(value) select value=value+1enddeclare employee_cursor cursorforselect ,from employee t join sell_order s on =where 15000open employee_cursorFETCH NEXT FROM employee_cursorWHILE fetch_status = 0 BEGIN FETCH NEXT FROM employee_cursorEND42select employee_name, case (datediff(yy,birth_date,getdate())1)/10 when 2 then 39。 WHEN classification_id=39。 WHEN classification_id=39。 WHEN classification_id=39。23SELECT 部門名,MIN(出生日期) FROM 部門 JOIN 職工 ON = GROUP BY 部門名24select 姓名,性別,(year(getdate())year(出生日期)) as 年齡 from 職工 where (year(getdate())year(出生日期))3525select 部門名,count(職工號(hào)) as 職工人數(shù) from 職工,部門 where = group by 部門名 having count(*)=2 order by count(*) descselect 部門名,count(*) as 職工人數(shù) from 職工 inner join 部門 on = group by having count(*)=1 order by count(*) desc第七章 索引與視圖一、選擇題CCADB二、填空題alter table, drop indexprimary key, unique視圖定義計(jì)算列修改，刪除第八章 數(shù)據(jù)完整性一、選擇題BCCAD二、填空題行create rule和create default唯一性primary key ，多檢查，唯一性constraint，約束名四、應(yīng)用題第八章應(yīng)用題1alter table sell_orderadd order_id1 int identity(1,2)alter table sell_orderdrop column order_id12alter table sell_orderadd primary key(order_id1)3use salesalter table customeradd primary key(customer_id)alter table sell_orderadd foreign key(custom_id) references customer(customer_id) on delete cascade on update cascade4alter table customeradd constraint kk unique(customer_name)5alter table sell_orderadd constraint k3 default (0)for discount6alter table sell_orderadd constraint k4 check (order_datesend_date),check (send_datearriver_date)第九章 TSQL程序設(shè)計(jì)一、選擇題BCCDD二、填空題局部44,82,126gf/* */單條，beginendbreak, continuedeclare cursor, select四、應(yīng)用題SELECT goods_name as 商品名稱, CASE WHEN classification_id=39。select ,姓名,性別,convert(varchar,出生
法律信息相關(guān)推薦
鄂ICP備17016276號(hào)-1