[dbo].[mod]

(local) > mdb > Scalar-valued Functions > dbo.mod

Properties
Parameters
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@num	int	4
@num2	int	4

Permissions

Type	Action	Owning Principal
Grant	Execute	public

SQL Script

/****** Object:  User Defined Function dbo.mod    Script Date: 12/1/2005 11:50:34 PM ******/

CREATE FUNCTION [dbo].[mod](@num int, @num2 int )
RETURNS int AS
BEGIN
    RETURN ROUND(@num, 0, 1) % ROUND(@num2, 0, 1)
END
GO
GRANT EXECUTE ON  [dbo].[mod] TO [public]
GO

Uses

Used By

[dbo].[statview]