ITBeginner

Build the function for return table to the calling statement.

CREATE FUNCTION SearchModule(
)
RETURNS @AppendText TABLE (
modTest varchar(500)
) As
BEGIN
INSERT INto @AppendText (modTest)
SELECT m.HEADER FROM MODULE_INFORMATION m
WHERE m.PROJECT_ID = 1
RETURN
END


This entry was posted on Wednesday, May 28th, 2008 at 1:36 pm and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.