4 ms·
Wow, that's fantastic. My queries are littered with that type of construct. Unfortunately, we are using SQL Server and Microsoft hardly ever makes any develop
by wvenable 12y ago
Wow, that's fantastic. My queries are littered with that type of construct. Unfortunately, we are using SQL Server and Microsoft hardly ever makes any developer-friendly enhancements to T-SQL.
- tracker1 12y agoTrue enough... I can't even begin to wrap my head around the XML wrangling functions in T-SQL, I feel like a n00b copying JS methods for jQuery when I go there. That said, it's probably one of the easiest RDBMS servers to administrate for small-medium sized deployments.
- sarciszewski 12y agoI've written migration unit testing tools before between SQL Server and PostgreSQL specifically (there are specific gotchas between the two). If you need help migrating to PGSQL send me an email and I'll help you escape from MSSQHell. :D