Syntax to Create User Defined Functions in SQL
CREATE FUNCTION <function_name> (<@paramater_name> <datatype>)
RETURNS <return_datatype>
AS
BEGIN
<DML statements>
RETURN expression
ENDSyntax to Create User Defined Functions in SQL
CREATE FUNCTION <function_name> (<@paramater_name> <datatype>)
RETURNS <return_datatype>
AS
BEGIN
<DML statements>
RETURN expression
ENDfunctions 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
EXEC @OrderID = dbo.GetOrderID
@OrderType = @OrderType,
@ServiceSpeed = @Qty,
@Qty = @ServiceSpeed;user defined variables in sql
SET @var_name = expr [, @var_name = expr] ...user defined function sql
Collation is defined as a set of rules
that determine how data can be sorted
as well as compared. Character data is
sorted using the rules that define the
correct character sequence along with
options for specifying case-sensitivity,
character width etc.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
