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 vote193 views1 answer
Sql database size
SQL
0 vote119 views1 answer
How to start my sql server on mac
SQL
0 vote109 views1 answer
Myswql show full processlist
SQL
2 votes153 views1 answer
Oracle log files
SQL
12 votes118 views4 answers
Mysql version query
SQL
2 votes247 views5 answers
Unique in sql server
SQL
6 votes112 views4 answers
Delete table sqlite
SQL
0 vote105 views1 answer
Query on date sqlite flutter
SQL
1 vote118 views1 answer
Table information in sql server
SQL
7 votes130 views3 answers
Sql server reset auto increment
SQL