Packages in SQL Server

Hi: Can any one please give me an example of Package in SQL server which i can test.
Thanks.What sort of package? Maybe you should ask at UPS?|||I am guessing you are coming from Oracle. MSSQL does not have packages like Oracle. However in 2005, there is something sort of similar, which is a CLR assembly. You can implement procs, functions, types, triggers, etc in an assembly and then expose them in sql.

Here are some examples:

http://msdn2.microsoft.com/en-us/library/ms131046.aspx