Wednesday, May 30, 2007

Syntax to create user difined functions for SQL 2000

Syntax:
CREATE FUNCTION [ owner_name. ] function_name
(
[ { @parameter_name [ AS ] data_type }[ ,...n ] ]
)
RETURNS data_type
[ AS ]
BEGIN
function_body
RETURN scalar_expression
END

Example:
CREATE FUNCTION sampleFunc(@num1 INT,@num2 INT)
RETURNS INT
AS
BEGIN
RETURN (@num1 * @num2)
END

No comments: