create function dbo.my_func(@val1 int,@val2 int) returns int as begin
if @val1 > @val2 set @val1 = @val2 return @val1 end goselect dbo.my_func(1,2)drop function dbo.my_func/*
----------- 1(所影响的行数为 1 行) */
CREATE FUNCTION dbo.small_fun(@num1 int,@num2 int) RETURN INT AS BEGIN RETURN CASE WHEN @num1>@num2 THEN @num1 ELSE @num2 END END GODECLARE @num1 INT,@num2 INT;SET @num1=ABS(CHECKSUM(NEWID()))%100; SET @num2=ABS(CHECKSUM(NEWID()))%100;SELECT dbo.small_fun(@num1,@num2);
RAND ( [ seed ] )
--2create function dbo.my_func(@val1 int,@val2 int) returns int as begin
if @val1 > @val2 set @val1 = @val2 return @val1 end goselect dbo.my_func(cast(RAND() * 100 as int) ,cast(RAND() * 100 as int))drop function dbo.my_func/*
as
begin
if @val1 > @val2
set @val1 = @val2
return @val1
end
goselect dbo.my_func(1,2)drop function dbo.my_func/*
-----------
1(所影响的行数为 1 行)
*/
RETURN INT
AS
BEGIN
RETURN CASE WHEN @num1>@num2 THEN @num1 ELSE @num2 END
END
GODECLARE @num1 INT,@num2 INT;SET @num1=ABS(CHECKSUM(NEWID()))%100;
SET @num2=ABS(CHECKSUM(NEWID()))%100;SELECT dbo.small_fun(@num1,@num2);
as
begin
if @val1 > @val2
set @val1 = @val2
return @val1
end
goselect dbo.my_func(cast(RAND() * 100 as int) ,cast(RAND() * 100 as int))drop function dbo.my_func/*
-----------
1(所影响的行数为 1 行)
*/