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

5 votes167 views2 answers
Sql server port number
SQL
4 votes158 views1 answer
Mysql insert from local csv
SQL
0 vote121 views1 answer
Mysqli or pdo
SQL
0 vote213 views1 answer
Oracle sql date winter time
SQL
0 vote188 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote169 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote175 views1 answer
How to select a row in sql
SQL
0 vote182 views3 answers
Sql drop all tables
SQL
0 vote181 views1 answer
Distance calculator from lat long sql query
SQL
4 votes185 views2 answers
Delete all table oracle
SQL