SQL Server Extended Stored Procedures

[Anil Kumar Saharan]

Hi, I am writing a few extended stored procedures for SQL Server database. A few of the functionality limitations for which I could find any answers are as below, - How can we pass data that is larger than 255 characters to the extended stored procedure as parameter? Similarly is there a way to pass the long data results back (basically strings with length > 255) - How can we use the resultset returned by the extended stored procedure as a virtual table in the T-SQL functions/procedures? Has anyone else come across these limitations? Kindly share any possible logical solution to overcome these situations. Thanks in anticipation :) Anil