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 vote167 views1 answer
Set classpath for mysql-connector.jar
SQL
-1 vote152 views5 answers
Convert sql to linq query online
SQL
0 vote138 views1 answer
Sql count * vs count 1
SQL
0 vote179 views1 answer
Grouping by email domain mysql
SQL
1 vote141 views1 answer
Oracle get current schema
SQL
1 vote138 views1 answer
Import database from a file using mysql commandline
SQL
4 votes141 views3 answers
How to describe a table in sqlite3
SQL
0 vote157 views1 answer
Helptext in sql
SQL
16 votes130 views1 answer
Mysql reset auto increment value
SQL
0 vote170 views1 answer
Mysql subtract month from timestamp
SQL