User defined function sql

Syntax to Create User Defined Functions in SQL

CREATE FUNCTION <function_name> (<@paramater_name>    <datatype>)
RETURNS <return_datatype>
AS
BEGIN
 	<DML statements>
    RETURN expression
END

Source: geeksarray.com

Functions with parameters SQL

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

Source: scribnasium.com

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.

-2

Similar codes

0 vote131 views1 answer
Basic structure of sql expression having clause
SQL
3 votes132 views1 answer
Oracle apex call duration
SQL
2 votes139 views1 answer
How to get weekday from old date in sql
SQL
2 votes121 views1 answer
Oracle cpu per session
SQL
22 votes135 views3 answers
SQL CHEATSHEET
SQL
0 vote138 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote150 views1 answer
Postgres clear table
SQL
2 votes135 views2 answers
Laravel query builder toSql
SQL
7 votes143 views2 answers
Sql remove duplicates based on column
SQL
1 vote172 views1 answer
Postgres set sequence value to max id
SQL