For a domain specific language, in this case the domain being data management, T-Sql gets the job done. Having worked with both it (in MS and Sybase) as well as weith Oracle's PL/SQL, it has feature level advantages as well as disadvantages, but I've not found it lacking unless you're trying to build the entire application within stored procs.

I think those who say that it's missing features are using it in places where C# or others should play a stronger part. In this case you shoud be building application components or .NET assemblies (XP's in earlier SQL Server releases) that can extend the funcitonality of the lowly stored procs.

In other words, T-SQL is a usefull tool, but it's not a hammer and the worlds not a nail. 🙂