SQL Server Issues
uProblems to overcome:
Ø1. The SQL Server development culture is not as sophisticated.
Ø2. SQL Server does not include a CONNECT BY clause to support recursive structures.
§No industry standard workaround
Ø3. SQL Server does not include sequences.
§No industry standard workaround
uAnnoyances to deal with:
ØSQL Server has an 8,000 character limit per record.
ØNo PL/SQL
ØNo casting collections to tables
ØINSTEAD OF trigger views are new.