SQL Server动态化列名数据

最新推荐文章于 2024-07-12 14:26:59 发布

IT-例子

最新推荐文章于 2024-07-12 14:26:59 发布

阅读量619

点赞数 12

文章标签：数据库服务器

本文链接：https://blog.csdn.net/qq_43001132/article/details/135155550

版权

SQL Server动态化列名数据

DECLARE @ColumnName NVARCHAR(100)
SET @ColumnName = '总数' + CAST(DATEPART(HOUR, GETDATE()) AS NVARCHAR) + '点前派单'
DECLARE @Sql NVARCHAR(MAX)
SET @Sql = 'SELECT COUNT(1) AS ' + QUOTENAME(@ColumnName) + '
FROM MBHZJ_GD
WHERE "SN码" IS NULL AND CAST(boss归档时间 AS date) LIKE ''2023-12-21%'''
EXEC sp_executesql @Sql

DECLARE @ColumnName NVARCHAR(100)
SET @ColumnName = '总数' + CAST(DATEPART(HOUR, GETDATE()) AS NVARCHAR) + '点前派单'
DECLARE @DateFilter NVARCHAR(20)
SET @DateFilter = CONVERT(NVARCHAR(10), GETDATE()-1, 23) + '%'
DECLARE @Sql NVARCHAR(MAX)
SET @Sql = 'SELECT COUNT(1) AS ' + QUOTENAME(@ColumnName) + '
FROM MBHZJ_GD
WHERE "SN码" IS NULL AND CAST(boss归档时间 AS DATE) LIKE ' + QUOTENAME(@DateFilter, '''') 
EXEC sp_executesql @Sql