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

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.