Answers for "how to execute function in sql with parameters and store them within the function for use"

Whatever

0

functions with parameters SQL

DECLARE
	@OrderID int = NULL,
	@OrderType int = 1,
	@Qty int = 2,
	@ServiceSpeed int = 3;

INSERT INTO OrdersTest (OrderType, Qty, ServiceSpeed)
	VALUES (@OrderType, @Qty, @ServiceSpeed);

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

SELECT @OrderID 'Using EXEC Syntax';

Posted by: Guest on July-15-2020

Source

Code answers related to "how to execute function in sql with parameters and store them within the function for use"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#