Hacker News Reader

as a user of TSQL in a MSFT/Azure shop, I feel increasingly isolated from other dialects. Virtually all other databases these days use a dialect that's closer to PostGres. Does TSQL have a future? If you don't have legacy dbs and you have a choice of dbs, would TSQL ever make sense to use today?

View on HN

T-SQL has huge warts, but is one of the better procedural SQL languages I've used. TDS (the wire protocol) also has warts, but it is vastly superior to the pg wire v3 protocol. Lastly, T-SQL is a single, integrated language, which means you can go from basic SQL to procedural SQL in the same batch. T-SQL also has first class support for multiple result sets which is very useful. T-SQL and TDS both support named parameters, where as PG only supports ordinal position.

Yes, it has a future.

Reply on news.ycombinator.com