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 vote174 views1 answer
Mysql update sum same table
SQL
2 votes193 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote196 views1 answer
UNION ALL LEFT JOIN
SQL
1 vote170 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
58 votes352 views6 answers
Create new user in postgres
SQL
0 vote187 views1 answer
Psql no such file or directory
SQL
2 votes195 views2 answers
How to check database username and password in postgresql
SQL
0 vote206 views1 answer
Mariadb set vertical output format
SQL
0 vote193 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote191 views1 answer
Mysql count number of occurrences in a column
SQL