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

10 votes360 views4 answers
Inner join in update query mysql
SQL
8 votes355 views3 answers
Alter table auto_increment
SQL
0 vote374 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote348 views1 answer
Oracle get running queries
SQL
0 vote337 views1 answer
Sqlite3 not commit
SQL
0 vote379 views1 answer
Mysql locate
SQL
0 vote421 views2 answers
Clauses in mysql
SQL
-1 vote391 views1 answer
Mysql faster insert
SQL
0 vote391 views1 answer
Show specific events on mysql
SQL
0 vote360 views1 answer
Exec procedure oracle
SQL