SQL Server Solutions
uPrimary key sequences
ØUse SQL Server identity columns (auto-populate numeric columns)
ØUse identity columns like sequences
uCONNECT BY problem
ØUse 7-level self-join
u8,000 character limit
ØRemove all VARCHAR2(4000) fields
uNo PL/SQL
ØMove all logic to the middle tier
ØAvoid SQL Server scripting