functions with parameters SQL
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
GOfunctions with parameters SQL
SET @OrderID = dbo.GetOrderID (default, default, default);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';functions with parameters SQL
EXEC @OrderID = dbo.GetOrderID
@OrderType = @OrderType,
@ServiceSpeed = @Qty,
@Qty = @ServiceSpeed;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
