随笔分类 -  SQL SERVER 动态SQL创建列

动态SQL根据日期创建列
摘要：SELECT * INTO #dates FROM ( SELECT DATEADD(day, number, '2021-01-01') AS date, ABS(CAST(CAST(NEWID() AS BINARY(3)) AS INT)) AS value FROM master..spt_ 阅读全文
posted @ 2023-01-11 16:01 狠毒男孩 阅读(263) 评论(0) 推荐(0)