物业信息管理形考答案.doc

1 123C/SB/S456/ 12342 123CPUCPU/CPUALU/ALUALU/ALUALUCPUABC4CPUCPUI/OCPUI/O56CPUI/OI/OI/OI/OI/OCPUI/ORAMI/OCPUI/OI/ODMADMACPUDMADMAI/OCPU7IT89()10 3 1 23()DBMS()DBMS()4.5.SQL SERVER 2000 Sql server 2000SQL SERVERSQLSERVERSQLSERVERSQLSERVERTRANNSACTSQL6.SQL Server2000SQL ServerMaster SQL ServerModel Tempdb Msdb SQL Server AgentPubsNorthwindSQL Server7.Tansact-SQLliquanUse northwindGrant Create TableCreate ProcedureTo liquanliquanProductsSelectInsertUpdateUse northwindRevoke SelectInsertUpdateOn ProductsFrom liquanliquanProductsSelectInsertUpdate()Use northwindDeny SelectInsertUpdateOn ProductsTo liquan8.Tansact-SQLDickTomcompanyemployeeinsertupdate1DickUse masterGrant create databasecreate table to Dick2TomcompanyemployeeinsertupdateUse companyDeny insertupdateOn employee to Tom()Use companyRevoke insert,updateOn employee to tom9.Tansact-SQLID02202101010Use If (select from where ID=02202)15Print 10ElsePrint 1010.pubsUSE pubsGOWHILE (SELECT AVG(price) FROM titles) $50BREAKELSECONTINUEENDPRINT Too much for the market to bear30*23050Too much for the market to bear 1JL365 S20002! 4 1.:/:2.Structured Approach3. 4.BSP:1)2)3)4)5)6)BSPIBM207056 7 121)2)3SDSD456 123