所有要求都是用sql sever语句实现 创建一个数据库，至少里面有5个表，每个表至少有十条数据，至少有两个表具有外键， 使用模式匹配查询，使用top查询，in查询，降序查询，使用count集合函数查询，分组统计查询，使用连接条件的多表查询，比较运算符的子查询，使用in的子查询 创建视图并使用 创建索引 创建唯一性约束，检查约束，默认值约束，外键约束 创建一个存储过程并使用 在某个表上创建一个插入和更新的dml触发器

好的，以下是实现您要求的 SQL Server 语句：

1. 创建数据库：

CREATE DATABASE TestDB

2. 创建表格：

CREATE TABLE Employee (
    EmployeeID int PRIMARY KEY,
    FirstName varchar(50),
    LastName varchar(50),
    DepartmentID int FOREIGN KEY REFERENCES Department(DepartmentID)
)

CREATE TABLE Department (
    DepartmentID int PRIMARY KEY,
    DepartmentName varchar(50)
)

CREATE TABLE Product (
    ProductID int PRIMARY KEY,
    ProductName varchar(50),
    CategoryID int FOREIGN KEY REFERENCES Category(CategoryID)
)

CREATE TABLE Category (
    CategoryID int PRIMARY KEY,
    CategoryName varchar(50)
)

CREATE TABLE Order (
    OrderID int PRIMARY KEY,
    OrderDate date,
    EmployeeID int FOREIGN KEY REFERENCES Employee(EmployeeID)
)

3. 插入数据：

INSERT INTO Employee VALUES (1, 'John', 'Doe', 1)
INSERT INTO Employee VALUES (2, 'Jane', 'Doe', 2)
INSERT INTO Department VALUES (1, 'Sales')
INSERT INTO Department VALUES (2, 'Marketing')
INSERT INTO Product VALUES (1, 'Phone', 1)
INSERT INTO Product VALUES (2, 'Laptop', 1)
INSERT INTO Category VALUES (1, 'Electronics')
INSERT INTO Category VALUES (2, 'Clothing')
INSERT INTO Order VALUES (1, '2022-01-01', 1)
INSERT INTO Order VALUES (2, '2022-01-02', 2)

4. 使用模式匹配查询：

SELECT * FROM Employee WHERE LastName LIKE 'Do%'

5. 使用 TOP 查询：

SELECT TOP 5 * FROM Employee

6. 使用 IN 查询：

SELECT * FROM Product WHERE CategoryID IN (1, 2)

7. 降序查询：

SELECT * FROM Employee ORDER BY EmployeeID DESC

8. 使用 COUNT 集合函数查询：

SELECT COUNT(*) FROM Employee

9. 分组统计查询：

SELECT DepartmentID, COUNT(*) FROM Employee GROUP BY DepartmentID

10. 使用连接条件的多表查询：

SELECT Employee.FirstName, Department.DepartmentName
FROM Employee
JOIN Department ON Employee.DepartmentID = Department.DepartmentID

11. 比较运算符的子查询：

SELECT * FROM Product WHERE ProductID = (SELECT MAX(ProductID) FROM Product)

12. 使用 IN 的子查询：

SELECT * FROM Product WHERE CategoryID IN (SELECT CategoryID FROM Category WHERE CategoryName = 'Electronics')

13. 创建视图并使用：

CREATE VIEW EmployeeView AS
SELECT Employee.FirstName, Employee.LastName, Department.DepartmentName
FROM Employee
JOIN Department ON Employee.DepartmentID = Department.DepartmentID

SELECT * FROM EmployeeView

14. 创建索引：

CREATE INDEX idx_Employee_LastName ON Employee(LastName)

15. 创建唯一性约束：

ALTER TABLE Employee ADD CONSTRAINT uc_Employee_EmployeeID UNIQUE (EmployeeID)

16. 检查约束：

ALTER TABLE Employee ADD CONSTRAINT chk_Employee_EmployeeID CHECK (EmployeeID > 0)

17. 默认值约束：

ALTER TABLE Employee ADD CONSTRAINT df_Employee_DepartmentID DEFAULT 1 FOR DepartmentID

18. 外键约束：

ALTER TABLE Employee ADD CONSTRAINT fk_Employee_DepartmentID FOREIGN KEY (DepartmentID) REFERENCES Department(DepartmentID)

19. 创建存储过程并使用：

CREATE PROCEDURE sp_GetEmployeeByID
    @EmployeeID int
AS
BEGIN
    SELECT * FROM Employee WHERE EmployeeID = @EmployeeID
END

EXEC sp_GetEmployeeByID 1

20. 创建插入和更新的 DML 触发器：

CREATE TRIGGER tr_Employee_InsertUpdate
ON Employee
AFTER INSERT, UPDATE
AS
BEGIN
    -- Your logic here
END