You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

Thanks for the info all.<BR><BR>For my current need, a trimmed format did the trick but I'll keep in mind datepart and datename.

Why offer server code instead of client code? T-SQL provides solutions to this display problem as illustrated above, but are these the right solutions for your situation? The ...

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code.

The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new ...

SQL Server 2014’s biggest new feature is in-memory transaction processing, or in-memory OLTP, which Microsoft claims can make database operations as much as 30 times faster.

Entity Framework Core 8 Preview 2 was released on March 14th. The most notable feature in EF Core 8 preview 2 is support for SQL Server hierarchical data.

SQL Query Store is a new feature offered in SQL Server 2016 that allows DBAs to see which queries ran when, how often and with what performance results to optimize queries and query plan selection.

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code.