數(shù)據(jù)庫技術(shù)與應用-sqlserver20xx課后答案-資料下載頁
2025-06-26 05:48本頁面
【正文】 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)建的角色、將這個角色授予某個用戶四、應用題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二、填空題磁盤備份設備、磁帶設備、命名通道設備backup database restore database完全、事務日志、差異、文件和文件組簡單恢復模型、完全恢復模型、大容量日志記錄恢復模型四、應用題(臨時備份設備)進行備份與還原數(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 17
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1