ALTER PROCEDURE [dbo].[Pro_Temp2]
AS
BEGIN
SET NOCOUNT ON;SELECT * FROM NewPublic
ENDCREATE FUNCTION Fun_Temp
(
)
RETURNS TABLE
AS
RETURN
(
EXEC dbo.Pro_Temp2
)
GO為什么出錯了。
Msg 156, Level 15, State 1, Procedure Fun_Temp, Line 8
Incorrect syntax near the keyword 'EXEC'.
Msg 102, Level 15, State 1, Procedure Fun_Temp, Line 9
Incorrect syntax near ')'.有人問“為什么不直接調用存儲過程”,我有這方面的需求。必須要用
函數。
(
SELECT * FROM NewPublic
)
goCREATE FUNCTION Fun_Temp()
RETURNS @T TABLE (...)
ASBEGIN将dbo.Pro_Temp2的逻辑写在这里,将结果集放到 @TreturnEND[/code]