數(shù)據(jù)庫技術(shù)與應(yīng)用-sqlserver20xx劉衛(wèi)國熊擁軍主編課后習(xí)題答案-資料下載頁
2025-06-26 06:07本頁面
【正文】 atetime,@order_id2 char(6) OUTPUTASBEGIN INSERT INTO sell_order(Order_ID1,goods_id,employee_id,Custom_ID,Transporter_ID,order_date) 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。S0000939。,39。G0000539。,39。e01039。,39。C000939。,39。T01039。,39。39。,@order_id2 OUTPUTSELECT @order_id22create proc chapter10_4_2as begin create table temp (id int) declare @n int select @n=1 while (@n=100) begin insert temp values(@n) select @n=@n+1 end select * from tempendexec chapter10_4_23create proc prupdatename @g_id char(6),@g_name varchar(50)asbegin update goods set goods_name=@g_name where goods_id=@g_idendexec prupdatename 39。G000839。,39。IBM T5139。4CREATE PROC prTest ASSELECT * FROM goodsIF EXISTS(SELECT * FROM sysobjects WHERE name=39。prTest39。) print 39。存在此存儲過程39。ELSE print 39。不存在此存儲過程39。5EXEC sp_helptext prTest6EXEC sp_depends prTest7EXEC sp_rename 39。prTest39。,39。npr_Test39。8DROP PROC npr_Test第十一章 數(shù)據(jù)庫的安全管理一、選擇題CDBC二、填空題登錄賬號，角色window身份驗證模式和混合模式對象、語句、隱含grant, revoke創(chuàng)建新的數(shù)據(jù)庫角色、分配權(quán)限給創(chuàng)建的角色、將這個角色授予某個用戶四、應(yīng)用題sp_addlogin 39。kwh39。,39。12345639。,39。sales39。use salessp_grantdbaccess 39。kwh39。,39。kwh239。sp_addrolemember 39。db_datareader39。,39。kwh239。sp_revokedbaccess 39。kwh239。sp_droplogin 39。kwh39。第十二章 數(shù)據(jù)庫的備份與還原一、選擇題ABAA二、填空題磁盤備份設(shè)備、磁帶設(shè)備、命名通道設(shè)備backup database restore database完全、事務(wù)日志、差異、文件和文件組簡單恢復(fù)模型、完全恢復(fù)模型、大容量日志記錄恢復(fù)模型四、應(yīng)用題(臨時備份設(shè)備)進行備份與還原數(shù)據(jù)庫backup database sales to disk=39。d:\back\39。restore database sales from disk=39。d:\back\39。exec sp_addumpdevice 39。disk39。,39。my239。,39。d:\back\39。backup database sales to my2restore database sales from my2覆蓋現(xiàn)有的數(shù)據(jù)庫restore database sales from my2 with replaceexec sp_addumpdevice 39。disk39。,39。my339。,39。d:\back\39。backup database sales to my3exec sp_addumpdevice 39。disk39。,39。my439。,39。d:\back\39。backup database sales to my4 with differentialrestore database sales from my3 with norecoveryrestore database sales from my4 with recoveryexec sp_addumpdevice 39。disk39。,39。my539。,39。d:\back\39。exec sp_addumpdevice 39。disk39。,39。my639。,39。d:\back\39。backup database sales to my5backup log sales to my6restore database sales from my5 with norecoveryrestore log sales from my6 with recovery 19
法律信息相關(guān)推薦
鄂ICP備17016276號-1