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 vote145 views2 answers
Athena drop partition
SQL
4 votes128 views1 answer
Mysql ip address
SQL
7 votes140 views2 answers
How to create index mysql
SQL
0 vote125 views1 answer
Case when with count and combining similar values in sql
SQL
1 vote133 views1 answer
Pl sql ptint
SQL
0 vote91 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
2 votes127 views1 answer
SELECT INTO
SQL
50 votes194 views6 answers
Sql duplicate rows
SQL
0 vote133 views1 answer
Difference between 2 query results sql server
SQL
1 vote152 views1 answer
Opensuse restart MySQL
SQL