3 ms·
For me I wish the language was more standardized between vendors. It would be nice if I could run my mssql statements against sqllite for quick testing. You d
by rileymat2 6y ago
For me I wish the language was more standardized between vendors.
It would be nice if I could run my mssql statements against sqllite for quick testing.
You don’t have to go deep before incompatibilities with ansi sql... top/limit statements.
- jpitz 6y agoIt would be nice, but at the same time, running mssql in a docker container is a thing now, and it goes pretty far towards solving those issues, at least for my use cases. >You don’t have to go deep before incompatibilities with ansi sql... top/limit statements. Neither TOP nor LIMIT are ANSI. We didn't get syntax in ANSI SQL for constraining rows until SQL 2008, with FETCH FIRST N ROWS. You could do it in SQL 2003 with window functions, but that was a bit wordy.