Posted by ArunDhaJ on 07/25/07 13:52

Hi Friends,
Is it possible to pass a table as a parameter to a funtion.

whos function declaration would look some thing like this....
ALTER FUNCTION TempFunction (@TempTable TABLE, @nPId INT)


my problem is: i have to access a temporary table created in an SP in
a function


ALTER PROCEDURE MySP
BEGIN
....
DECLARE @TmpTable TABLE(...)
....
TempFunction(@TmpTable)
....
END


Thanks
ArunDhaJ

• Next in forum: Database Design
• Prev in forum: Re: Error: The number of failing rows exceeded the maximum specified, Help !
• Thread view: Pass Table as a parameter to a function

[Reply to this message]