比如:
use northwind
create function Pay (@u money,@q smallint,@d real )
returns money
as
begin
declare @pay money
set @pay = @u*@q*(1-@d)
return @pay
endselect OrderID,ProductID,UnitPrice,Quantity,Discount, dbo.Pay(UnitPrice,Quantity,Discount) as 金额
from [Order Details]
use northwind
create function Pay (@u money,@q smallint,@d real )
returns money
as
begin
declare @pay money
set @pay = @u*@q*(1-@d)
return @pay
endselect OrderID,ProductID,UnitPrice,Quantity,Discount, dbo.Pay(UnitPrice,Quantity,Discount) as 金额
from [Order Details]
RETURNS @OrderShipperTab TABLE
(
ShipperID int,
ShipperName nvarchar(80),
OrderID int,
ShippedDate datetime,
Freight money
)
AS
BEGIN
INSERT @OrderShipperTab
SELECT S.ShipperID, S.CompanyName,
O.OrderID, O.ShippedDate, O.Freight
FROM Shippers AS S
INNER JOIN Orders AS O ON (S.ShipperID = O.ShipVia)
WHERE O.Freight > @FreightParm
RETURN
ENDSELECT *
FROM LargeOrderShippers( $500 ) --没有加dbo
属于创建该对象的用户,而不是 dbo。
用创建该对象的用户名限定。