范例如下:(来源网络)
ALTER FUNCTION fn_ab
(
@db VARCHAR(1)
)
RETURNS @r TABLE(col1 INT, ......) --定义返回的表结构
AS
BEGIN
IF (@db='1')
INSERT @r SELECT * FROM A
IF (@db='2')
INSERT @r SELECT * FROM B
RETURN
END
GO
------------------------------------------------------------------
[Python,SQL,ETL]交流群 164142295