Breaking News: Grepper is joining You.com. Read the official announcement!

create scalar function in sql server

Rasel Ahmed answered on June 14, 2022 Popularity 10/10 Helpfulness 4/10

answer create scalar function in sql server

create scalar function in sql server

Comment

CREATE FUNCTION [schema_name.]function_name (parameter_list)
RETURNS data_type AS
BEGIN
    statements
    RETURN value
END


----------------------------
CREATE FUNCTION sales.udfNetSale(
    @quantity INT,
    @list_price DEC(10,2),
    @discount DEC(4,2)
)
RETURNS DEC(10,2)
AS 
BEGIN
    RETURN @quantity * @list_price * (1 - @discount);
END;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: function scalar sql sql-server

Link to this answer
Share Copy Link

Contributed on Jun 14 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

create scalar function in sql server

Contents

More Related Answers

create scalar function in sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.