【正文】 spwebUpdateSelfIntro.......................................................... 137 . 存儲(chǔ)過程 spwebAddPerformObject ..................................................... 138 . 存儲(chǔ)過程 spwebDeletePerformItem ..................................................... 139 . 存儲(chǔ)過程 spwebGetDeptSalarySummary............................................. 140 . 存儲(chǔ)過程 spwebUpdatePerform .......................................................... 141 . 存儲(chǔ)過程 spwebUpdatePerformItem .................................................... 142 詳細(xì)設(shè)計(jì)說明書 5 . 存儲(chǔ)過程 spwinAttendanceQuery ........................................................ 143 . 存儲(chǔ)過程 spwinChangeEmployeeDept ................................................ 144 . 存儲(chǔ)過程 spwinCreateDepartment....................................................... 145 . 存儲(chǔ)過程 spwinDeleteDepartment ....................................................... 146 . 存儲(chǔ)過程 spwinDeleteEmployee ......................................................... 147 . 存儲(chǔ)過程 spwinDelLeaveRequest ....................................................... 148 . 存儲(chǔ)過程 spwinDeptAllEmployee ........................................................ 149 . 存儲(chǔ)過程 spwinDeptLeave .................................................................. 150 . 存儲(chǔ)過程 spwinEmpLeave .................................................................. 151 . 存儲(chǔ)過程 spwinGetAllDepartment ....................................................... 152 . 存儲(chǔ)過程 spwinGetEmpbyDeptName .................................................. 153 . 存儲(chǔ)過程 spwinMoveEmpBetweenDept ............................................... 154 . 存儲(chǔ)過程 spwinRejectLeaveRequest ................................................... 155 . 存儲(chǔ)過程 spwebUpdatePerformItemSelf .............................................. 156 . 存儲(chǔ)過程 spwebUpdatePerformItemReview ......................................... 157 . 存儲(chǔ)過程 spwebGetSubmittedPerform................................................. 158 . 存儲(chǔ)過程 spwebGetDeptPerformSummary .......................................... 159 . 存儲(chǔ)過程 spwinOTbyGroup................................................................. 160 . 存儲(chǔ)過程 spwebPerformReviewed ...................................................... 162 . 存儲(chǔ)過程 spwinBasicSalaryByEmpID .................................................. 163 . 存儲(chǔ)過程 spwinSalaryHistoryByEmpID ................................................ 164 . 存儲(chǔ)過程 spwinSetBasicSalary ........................................................... 165 . 存儲(chǔ)過程 spwinQueryEventbyTime ..................................................... 166 . 存儲(chǔ)過程 spwinChangePassword........................................................ 167 . 存儲(chǔ)過程 spwinAddEvent ................................................................... 168 . 存 儲(chǔ)過程 spwebUpdatePerformItemObj............................................... 169 6. 用戶自定義函數(shù) .............................................................................................. 170 . 用戶自定義函數(shù) udfwinDeptAllEmployee ............................................. 170 . 用戶自定義函數(shù) udfwinGetDeptIDbyDeptName.................................... 171 . 用戶自定義函數(shù) udfwinGetDeptNamebyDeptID.................................... 172 7. 觸發(fā)器 ............................................................................................................ 173 . 觸發(fā)器 tRejectRequest ....................................................................... 173 詳細(xì)設(shè)計(jì)說明書 6 8. 數(shù)據(jù)庫安全性 .................................................................................................. 173 . 概述 .................................................................................................. 173 . 數(shù)據(jù)庫驗(yàn)證方式 ................................................................................. 173 詳細(xì)設(shè)計(jì)說明書 7 1. 概述 . 目的 本文為教學(xué)案例項(xiàng)目 SQL Server功能規(guī)范說明書。 . 與其他項(xiàng)目的關(guān)聯(lián) 教學(xué)案例項(xiàng)目的數(shù)據(jù)庫設(shè)計(jì)與教學(xué)項(xiàng)目（ Web 部分和 Windows 部分）功能密切相關(guān)。 , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N39。 end GO ALTER DATABASE [RGB] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [RGB] SET ANSI_NULLS OFF GO ALTER DATABASE [RGB] SET ANSI_PADDING OFF GO ALTER DATABASE [RGB] SET ANSI_WARNINGS OFF GO ALTER DATABASE [RGB] SET ARITHABORT OFF GO ALTER DATABASE [RGB] SET AUTO_CLOSE OFF GO ALTER DATABASE [RGB] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [RGB] SET AUTO_SHRINK OFF 詳細(xì)設(shè)計(jì)說明書 9 GO ALTER DATABASE [RGB] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [RGB] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [RGB] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [RGB] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [RGB] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [RGB] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [RGB] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [RGB] SET DISABLE_BROKER GO ALTER DATABASE [RGB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [RGB] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [RGB] SET TRUSTWORTHY OFF GO ALTER DATABASE [RGB] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [RGB] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [RGB] SET READ_COMMITTED_SNAPSHOT OFF GO 詳細(xì)設(shè)計(jì)說明書 10 ALTER DATABASE [RGB] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [RGB] SET READ_WRITE GO ALTER DATABASE [RGB] SET RECOVERY FULL GO ALTER DATABASE [RGB] SET MULTI_USER GO ALTER DATABASE [RGB] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [RGB] SET DB_CHAINING OFF GO . 用戶 除了數(shù)據(jù)庫中自動(dòng)創(chuàng)建的 dbo 用戶之外，還要?jiǎng)?chuàng)建如下兩個(gè)用戶： ? RGBWinUser：該用戶是 Windows 應(yīng)用程序訪問數(shù)據(jù)庫所使用的賬號(hào)，它的權(quán)限一般僅限于查看視圖和執(zhí)行存儲(chǔ)過程。 答案： USE [RGB] GO /****** Object: Index [PK_tblEmployee] Script Date: 06/18/2020 09:00:53 ******/ ALTER TABLE [dbo].[tblEmployee] ADD CONSTRAINT [PK_tblEmployee] PRIMARY 詳細(xì)設(shè)計(jì)說明書 15 KEY CLUSTERED ( [EmployeeI