Topic says it all. Anyone know the best way to write a median aggregate function in ms sql server 2k? I've seen a couple ways of doing it when I briefly searched google but they weren't presented ...

Using the CLR Function Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.

Function inlining in SQL Server 2019 Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. This means they will be folded into the query and no longer incur the UDF ...