IF OBJECT_ID('FUN_MAX')IS NOT NULL DROP FUNCTION FUN_MAX
GO
CREATE FUNCTION FUN_MAX(@A INT,@B INT,@C INT)
RETURNS INT
AS
BEGIN
DECLARE @MAX INT
DECLARE @T TABLE(NUM INT)
INSERT @T SELECT @A
INSERT @T SELECT @B
INSERT @T SELECT @C
SELECT @MAX=MAX(NUM) FROM @T
RETURN @MAX
END
GO
SELECT DBO.FUN_MAX(8,10,5)
/*
-----------
10*/
GO
CREATE FUNCTION FUN_MAX(@A INT,@B INT,@C INT)
RETURNS INT
AS
BEGIN
DECLARE @MAX INT
DECLARE @T TABLE(NUM INT)
INSERT @T SELECT @A
INSERT @T SELECT @B
INSERT @T SELECT @C
SELECT @MAX=MAX(NUM) FROM @T
RETURN @MAX
END
GO
SELECT DBO.FUN_MAX(8,10,5)
/*
-----------
10*/
INSERT @T SELECT @A
INSERT @T SELECT @B
INSERT @T SELECT @C
SELECT @MAX=MAX(NUM) FROM @T这一段不太明白??
SELECT dbo.FUN_MAX(3,2,5)
为什么要用 dbo 来点啊??