Code Changes while migrating sql server 2000 to 2005

Can you please let me know what all key changes required in stored procedure / functions while migrating project from 2000 to 2005 instance.

Thanks

Sujay