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 vote218 views2 answers
How to prevent sql injection in java
SQL
0 vote190 views1 answer
Sql cross apply vs join
SQL
0 vote205 views1 answer
Sql show all users
SQL
0 vote255 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote250 views1 answer
Kimball data warehouse sql calendar
SQL
2 votes188 views3 answers
How to get second highest salary in each department in sql
SQL
7 votes215 views1 answer
Oracle pagination query rownum
SQL
7 votes196 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote192 views1 answer
Column with prefix in sql
SQL
0 vote209 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL