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 vote190 views3 answers
Classement rang mysql 7
SQL
1 vote205 views3 answers
Postgresql get difference between two dates
SQL
0 vote190 views1 answer
Sql delete from with relation
SQL
1 vote166 views1 answer
Foreign key constraint in ms sql
SQL
2 votes150 views2 answers
Mysql get last character of string
SQL
0 vote181 views2 answers
Mysql on update current_timestamp
SQL
17 votes187 views6 answers
Get last record in sql
SQL
15 votes189 views6 answers
Psql
SQL
1 vote180 views1 answer
Sql server 2016 reseed identity
SQL
1 vote184 views1 answer
Oracle sql create view
SQL