Sql Server Limitations

Thong Nguyen edited this page Feb 27, 2015 · 2 revisions
  • No support for deferrable constraints
  • Incompatibility between true boolean and bit values resulting in complex queries
  • No support for OFFSET/LIMIT resulting in complex queries
  • Subqueries that contain ORDER BY need TOP (Shaolinq automatically inserts these)