sql的存储过程中可否用table 型作参数，怎样用

存储过程不支持的
可以考虑使用用户定义函数来实现，如：
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