SQL Server 中视图中的 IF 条件

使用 IF 条件在 SQL Server 视图中进行数据筛选

sql
CREATE VIEW SalesView AS
SELECT 
    ProductID,
    SalesAmount,
    CASE 
        WHEN SalesAmount > 1000 THEN 'High Sales'
        ELSE 'Low Sales'
    END AS SalesCategory
FROM SalesData
WHERE
    YEAR(OrderDate) = 2023;

sql
CREATE VIEW DynamicSalesView AS
SELECT 
    ProductID,
    SalesAmount,
    CASE 
        WHEN @FilterType = 'HighSales' AND SalesAmount > 1000 THEN 'High Sales'
        WHEN @FilterType = 'LowSales' AND SalesAmount <= 1000 THEN 'Low Sales'
        ELSE 'All Sales'
    END AS SalesCategory
FROM SalesData
WHERE
    YEAR(OrderDate) = @Year;