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

functions with parameters SQL

Famous Fowl answered on July 15, 2020 Popularity 9/10 Helpfulness 2/10

answer functions with parameters SQL

related functions with parameters SQL

functions with parameters SQL

Comment

SET @OrderID = dbo.GetOrderID (default, default, default);

Popularity 9/10 Helpfulness 2/10 Language sql

Source: scribnasium.com

Tags: parameters sql

Link to this answer
Share Copy Link

Contributed on Jul 15 2020

Famous Fowl

0 Answers Avg Quality 2/10

Closely Related Answers

functions with parameters SQL

Comment

USE tempdb;
GO

DROP FUNCTION IF EXISTS dbo.GetOrderID;
DROP TABLE IF EXISTS OrdersTest;
GO

CREATE TABLE OrdersTest (OrderID int IDENTITY, OrderType int, Qty int, ServiceSpeed int);
GO

CREATE FUNCTION GetOrderID
(
	@OrderType int = 0,
	@ServiceSpeed int = 0,
	@Qty int = 0
)
RETURNS int AS
BEGIN
	RETURN
	(
		SELECT
			TOP 1 OrderID
		FROM		OrdersTest
		WHERE		OrderType = @OrderType
		AND			ServiceSpeed = @ServiceSpeed
		AND			Qty = @Qty
		
	);
END
GO

Popularity 10/10 Helpfulness 3/10 Language sql

Source: scribnasium.com

Tags: parameters p

Link to this answer
Share Copy Link

Contributed on Jul 15 2020

Famous Fowl

0 Answers Avg Quality 2/10

functions with parameters SQL

Comment

EXEC @OrderID = dbo.GetOrderID
	@OrderType = @OrderType,
	@ServiceSpeed = @Qty,
	@Qty = @ServiceSpeed;

Popularity 9/10 Helpfulness 2/10 Language sql

Source: scribnasium.com

Tags: parameters p

Link to this answer
Share Copy Link

Contributed on Jul 15 2020

Famous Fowl

0 Answers Avg Quality 2/10

functions with parameters SQL

Contents

More Related Answers

functions with parameters SQL

Closely Related Answers

functions with parameters SQL

functions with parameters SQL

Grepper

Documentation

Social

Legal

Contact

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