CREATE FUNCTION Order_Customer
(@FirstName varchar(20),@LastName varchar(20))
RETURNS @Order_Customer_Tab TABLE
(
OrderID int,
GoodsName varchar(20),
CustomerName varchar(40)
)
BEGIN
INSERT @Order_Customer_Tab
SELECT OrderID,GoodsName,FirstName+','+LastName
FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID
WHERE FirstName = @FirstName AND LastName = @LastName
RETURN
END
SQL 用户自定义函数 传入table类型数据
最新推荐文章于 2020-04-04 13:24:16 发布