Hacker News new | ask | show | jobs
by hodgesrm 520 days ago
> An enormous flaw of Sybase/Microsoft SQL Server is that it does not implement the SQL/PSM standard.

Why is this a problem? I've always enjoyed T-SQL. Right from the start it had a "scripty" feel and stored procedures were easy to code with it. We thought about implementing PSM at Sybase in the 1990s but there was little user demand. (Unlike row level locking, the lack of which undid Sybase SAP implementations...) Internally many of the engineers thought PSM was pretty awful to use. I never liked it myself.
1 comments
chasil 519 days ago
It is an ANSI standard, implemented by many databases.

SQLite's trigger syntax appears to be conformant.

Transact SQL has much fewer implementations, and standards conformance enables interoperability. The SQL Server family is lacking in this respect.

link