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