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

2 votes322 views1 answer
Set auto increment from 1
SQL
13 votes301 views6 answers
Current date sql
SQL
0 vote318 views1 answer
Top frequency in sql server
SQL
0 vote304 views1 answer
Psql select * from table
SQL
0 vote297 views1 answer
Mysql_num_fields in mysqli
SQL
3 votes308 views2 answers
Sql select data from last week
SQL
5 votes290 views1 answer
Update sql user password
SQL
0 vote335 views1 answer
Ajouter une clé etrangere mysql
SQL
6 votes303 views1 answer
Check Table Exists
SQL
7 votes319 views4 answers
What is my mysql version
SQL