T-SQL : Sweet and Sour

I have working on SQL server 2005 (t-sql) lately. This blog is a comparison between the pl/sql features available in t-sql,db2 v 8.2 and oracle 9i pl/sql.
This blog will be updated when anything new turns up.
So here goes...

# Feature Available in SQL server 2005? DB2 Oracle 1 Exception handling Yes. yes yes 2 Transaction Yes. yes yes 3 ELSIF construct No yes yes 4 IF exists () Yes. yes no 5 Max column size 32000 32000 4000 6 Implicit Cursor No Yes Yes 7 Recursive query Yes. Similar to db2 but only 100 literations yes yes : using connect byprior 8 Print Command Yes No Yes 9 Dynamic SQL Yes Yes Yes 10 Dynamic SQL STRING DATATYPE nvarchar and nchar varchar varchar 11 Variable and cursor name same yes yes no 12 Default value while variable declaration no yes yes 13 Sequences No Yes yes