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

好的，我明白了您的要求。以下是我为您提供的 SQL Server 代码：

1. 创建数据库并创建表

-- 创建数据库
CREATE DATABASE MyDatabase

-- 选择数据库
USE MyDatabase

-- 创建表
CREATE TABLE Customers (
   CustomerID int PRIMARY KEY,
   CustomerName varchar(255),
   ContactName varchar(255),
   Country varchar(255)
);

CREATE TABLE Orders (
   OrderID int PRIMARY KEY,
   CustomerID int,
   OrderDate date,
   ShipperName varchar(255)
);

CREATE TABLE OrderDetails (
   OrderDetailID int PRIMARY KEY,
   OrderID int,
   ProductName varchar(255),
   Quantity int,
   Price decimal(10,2)
);

CREATE TABLE Products (
   ProductID int PRIMARY KEY,
   ProductName varchar(255),
   Category varchar(255),
   Price decimal(10,2)
);

CREATE TABLE Shippers (
   ShipperID int PRIMARY KEY,
   ShipperName varchar(255),
   Phone varchar(255)
);

-- 添加数据到表
INSERT INTO Customers (CustomerID, CustomerName, ContactName, Country)
VALUES 
   (1, 'Alfreds Futterkiste', 'Maria Anders', 'Germany'),
   (2, 'Ana Trujillo Emparedados', 'Ana Trujillo', 'Mexico'),
   (3, 'Antonio Moreno Taquería', 'Antonio Moreno', 'Mexico'),
   (4, 'Around the Horn', 'Thomas Hardy', 'UK'),
   (5, 'Berglunds snabbköp', 'Christina Berglund', 'Sweden'),
   (6, 'Blauer See Delikatessen', 'Hanna Moos', 'Germany'),
   (7, 'Blondesddsl père et fils', 'Frédérique Citeaux', 'France'),
   (8, 'Bólido Comidas preparadas', 'Martín Sommer', 'Spain'),
   (9, 'Bon app''', 'Laurence Lebihans', 'France'),
   (10, 'Bottom-Dollar Markets', 'Elizabeth Lincoln', 'Canada');

INSERT INTO Orders (OrderID, CustomerID, OrderDate, ShipperName)
VALUES 
   (1, 3, '2020-01-01', 'UPS'),
   (2, 5, '2020-01-02', 'DHL'),
   (3, 2, '2020-01-03', 'FedEx'),
   (4, 1, '2020-01-04', 'DHL'),
   (5, 4, '2020-01-05', 'UPS'),
   (6, 6, '2020-01-06', 'FedEx'),
   (7, 7, '2020-01-07', 'DHL'),
   (8, 9, '2020-01-08', 'UPS'),
   (9, 10, '2020-01-09', 'FedEx'),
   (10, 8, '2020-01-10', 'DHL');

INSERT INTO OrderDetails (OrderDetailID, OrderID, ProductName, Quantity, Price)
VALUES 
   (1, 1, 'Product A', 10, 100.0),
   (2, 1, 'Product B', 20, 200.0),
   (3, 2, 'Product C', 30, 300.0),
   (4, 2, 'Product A', 40, 400.0),
   (5, 3, 'Product B', 50, 500.0),
   (6, 3, 'Product C', 60, 600.0),
   (7, 4, 'Product A', 70, 700.0),
   (8, 4, 'Product B', 80, 800.0),
   (9, 5, 'Product C', 90, 900.0),
   (10, 5, 'Product A', 100, 1000.0);

INSERT INTO Products (ProductID, ProductName, Category, Price)
VALUES 
   (1, 'Product A', 'Category 1', 100.0),
   (2, 'Product B', 'Category 1', 200.0),
   (3, 'Product C', 'Category 2', 300.0),
   (4, 'Product D', 'Category 2', 400.0),
   (5, 'Product E', 'Category 3', 500.0),
   (6, 'Product F', 'Category 3', 600.0),
   (7, 'Product G', 'Category 4', 700.0),
   (8, 'Product H', 'Category 4', 800.0),
   (9, 'Product I', 'Category 5', 900.0),
   (10, 'Product J', 'Category 5', 1000.0);

INSERT INTO Shippers (ShipperID, ShipperName, Phone)
VALUES 
   (1, 'UPS', '1-800-742-5877'),
   (2, 'DHL', '1-800-225-5345'),
   (3, 'FedEx', '1-800-463-3339');

2. 使用模式匹配查询、top查询、in查询、降序查询、count集合函数查询、分组统计查询、连接条件的多表查询、比较运算符的子查询、使用in的子查询

-- 模式匹配查询
SELECT * FROM Customers WHERE CustomerName LIKE '%Alfreds%'

-- Top查询
SELECT TOP 5 * FROM Customers

-- In查询
SELECT * FROM Customers WHERE Country IN ('Germany', 'France')

-- 降序查询
SELECT * FROM Customers ORDER BY CustomerName DESC

-- Count集合函数查询
SELECT COUNT(*) FROM Customers

-- 分组统计查询
SELECT Country, COUNT(*) FROM Customers GROUP BY Country

-- 连接条件的多表查询
SELECT Customers.CustomerName, Orders.OrderDate, Shippers.ShipperName
FROM Customers
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
INNER JOIN Shippers ON Orders.ShipperName = Shippers.ShipperName

-- 比较运算符的子查询
SELECT CustomerName FROM Customers
WHERE CustomerID IN (SELECT CustomerID FROM Orders WHERE OrderDate > '2020-01-04')

-- 使用IN的子查询
SELECT * FROM Customers
WHERE Country IN (SELECT Country FROM Customers WHERE CustomerName = 'Alfreds Futterkiste')

3. 创建视图并使用

-- 创建视图
CREATE VIEW GermanCustomers AS
SELECT * FROM Customers WHERE Country = 'Germany'

-- 使用视图
SELECT * FROM GermanCustomers

4. 创建索引

-- 在Customers表上创建索引
CREATE INDEX idx_Customers_CustomerName ON Customers (CustomerName)

5. 创建约束

-- 创建唯一性约束
ALTER TABLE Customers ADD CONSTRAINT uc_Customers_CustomerName UNIQUE (CustomerName)

-- 创建检查约束
ALTER TABLE Products ADD CONSTRAINT chk_Products_Price CHECK (Price > 0)

-- 创建默认值约束
ALTER TABLE Products ADD CONSTRAINT df_Products_Category DEFAULT 'Unknown' FOR Category

-- 创建外键约束
ALTER TABLE Orders ADD CONSTRAINT fk_Orders_Customers FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)

ALTER TABLE OrderDetails ADD CONSTRAINT fk_OrderDetails_Orders FOREIGN KEY (OrderID) REFERENCES Orders(OrderID)

6. 创建存储过程并使用

-- 创建存储过程
CREATE PROCEDURE GetOrdersByCustomer
    @CustomerID int
AS
BEGIN
    SELECT * FROM Orders WHERE CustomerID = @CustomerID
END

-- 使用存储过程
EXEC GetOrdersByCustomer @CustomerID = 3

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

-- 创建插入的DML触发器
CREATE TRIGGER tr_Customers_Insert
ON Customers
FOR INSERT
AS
BEGIN
    PRINT 'A new record has been inserted into Customers table.'
END

-- 创建更新的DML触发器
CREATE TRIGGER tr_Customers_Update
ON Customers
FOR UPDATE
AS
BEGIN
    PRINT 'A record has been updated in Customers table.'
END

以上就是我为您提供的 SQL Server 代码，希望能够对您有所帮助。