-- 創(chuàng)建Employees表CREATE TABLE Employees (    EmployeeID INT IDENTITY(1,1) PRIMARY KEY,    FirstName VARCHAR(50),    LastName VARCHAR(50),    Position VARCHAR(50),    DepartmentID INT);
-- 插入Employees表數(shù)據(jù)INSERT INTO Employees (FirstName, LastName, Position, DepartmentID)VALUES ('Jane', 'Doe', 'Manager', 1),       ('John', 'Smith', 'Developer', 2),       ('Alice', 'Johnson', 'Developer', 2);

DECLARE @TableName NVARCHAR(128) = 'Employees';DECLARE @SQL NVARCHAR(MAX);
SET @SQL = 'SELECT * FROM ' + QUOTENAME(@TableName);
EXEC sp_executesql @SQL;

DECLARE @EmployeeID INT = 1;DECLARE @SQL NVARCHAR(MAX);
SET @SQL = N'SELECT * FROM Employees WHERE EmployeeID = @EmpID';
EXEC sp_executesql @SQL, N'@EmpID INT', @EmpID = @EmployeeID;

DECLARE @SortColumn NVARCHAR(128) = 'FirstName';DECLARE @SortOrder NVARCHAR(4) = 'ASC';DECLARE @PageSize INT = 10;DECLARE @PageNumber INT = 1;DECLARE @SQL NVARCHAR(MAX);
SET @SQL = N'SELECT * FROM (                SELECT ROW_NUMBER() OVER (ORDER BY ' + QUOTENAME(@SortColumn) + ' ' + @SortOrder + ') AS RowNum,                * FROM Employees             ) AS MyDerivedTable             WHERE MyDerivedTable.RowNum BETWEEN ' + CAST((@PageNumber - 1) * @PageSize + 1 AS NVARCHAR) +              ' AND ' + CAST(@PageNumber * @PageSize AS NVARCHAR);
EXEC sp_executesql @SQL;

DECLARE @ProcedureName NVARCHAR(128) = 'usp_GetEmployeeDetails';DECLARE @SQL NVARCHAR(MAX);
SET @SQL = N'CREATE PROCEDURE ' + QUOTENAME(@ProcedureName) + '             @EmployeeID INT             AS             BEGIN                 SELECT * FROM Employees WHERE EmployeeID = @EmployeeID;             END';
EXEC (@SQL);

-- 現(xiàn)在我們可以執(zhí)行新創(chuàng)建的存儲(chǔ)過(guò)程
EXEC usp_GetEmployeeDetails @EmployeeID = 1;