數(shù)據(jù)庫(kù)技術(shù)與應(yīng)用-sqlserver20xx課后答案-資料下載頁(yè)
2025-06-26 05:48本頁(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。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。存在此存儲(chǔ)過(guò)程39。ELSE print 39。不存在此存儲(chǔ)過(guò)程39。5EXEC sp_helptext prTest6EXEC sp_depends prTest7EXEC sp_rename 39。prTest39。,39。npr_Test39。8DROP PROC npr_Test第十一章 數(shù)據(jù)庫(kù)的安全管理一、選擇題CDBC二、填空題登錄賬號(hào)，角色window身份驗(yàn)證模式和混合模式對(duì)象、語(yǔ)句、隱含grant, revoke創(chuàng)建新的數(shù)據(jù)庫(kù)角色、分配權(quán)限給創(chuàng)建的角色、將這個(gè)角色授予某個(gè)用戶(hù)四、應(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ù)庫(kù)的備份與還原一、選擇題ABAA二、填空題磁盤(pán)備份設(shè)備、磁帶設(shè)備、命名通道設(shè)備backup database restore database完全、事務(wù)日志、差異、文件和文件組簡(jiǎn)單恢復(fù)模型、完全恢復(fù)模型、大容量日志記錄恢復(fù)模型四、應(yīng)用題(臨時(shí)備份設(shè)備)進(jìn)行備份與還原數(shù)據(jù)庫(kù)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ù)庫(kù)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)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1