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 vote187 views1 answer
How to count with except in psql
SQL
1 vote225 views1 answer
Mysql view curren querys
SQL
0 vote282 views1 answer
Get last inserted primary key
SQL
0 vote227 views1 answer
Postgres docs /copy metacomand
SQL
6 votes241 views1 answer
Postgresql get year
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
0 vote188 views1 answer
Python mysql query where
SQL
11 votes196 views6 answers
Distinct sql
SQL
0 vote198 views1 answer
Mysql make date from 2 column
SQL
1 vote222 views4 answers
Aggregate function in sql
SQL