CREATE function a(@cc varchar(20))
returns table --加上
return (SELECT TOP 1 AP FROM NA WHERE (LUN = @cc))
returns table --加上
return (SELECT TOP 1 AP FROM NA WHERE (LUN = @cc))
调试欢乐多
GO
CREATE FUNCTION SalesByStore (@storeid varchar(30))
RETURNS TABLE
AS
RETURN (SELECT title, qty
FROM sales s, titles t
WHERE s.stor_id = @storeid and
t.title_id = s.title_id)
returns varchar(50)
as
begin
declare @s varchar(50)
SELECT TOP 1 @s=AP FROM NA WHERE (LUN = @cc)
return @s
end