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

sql function that returns a scalar value

Nice Narwhal answered on November 17, 2023 Popularity 6/10 Helpfulness 1/10

answer sql function that returns a scalar value

sql function that returns a scalar value

Comment

---------------- Microsoft SQL Server ------------
-- function that returns a vendor ID
CREATE FUNCTION fnVendorID(@VendorName varchar(50))
	RETURNS int
BEGIN
	RETURN (SELECT VendorID FROM Vendors WHERE VendorName = @VendorName);
END;
-- A statement that invokes the scalar-valued function
SELECT InvoiceDate, InvoiceTotal
FROM Invoices
WHERE VendorID = dbo.fnVendorID('IBM');

Popularity 6/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: scalar sql sql-function

Link to this answer
Share Copy Link

Contributed on Nov 17 2023

Nice Narwhal

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.

sql function that returns a scalar value

Contents

More Related Answers

sql function that returns a scalar value

Grepper

Documentation

Social

Legal

Contact

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