testaggregate.sql

来自「< SQL Server2005程序设计>」· SQL 代码 · 共 2 行

SELECT OrderId, SUM(ItemsOrdered) AS SUM, dbo.BakersDozen(ItemsOrdered) AS BakersDozen FROM tblAggregateTest GROUP BY OrderId
SELECT dbo.BakersDozen(13) AS BakersDozen