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

1 vote254 views1 answer
Ora-01950 no privileges on tablespace
SQL
4 votes204 views2 answers
Select first and last row mysql
SQL
0 vote256 views1 answer
Bash block size ls /var/lib/mysql
SQL
-1 vote207 views1 answer
Window functions in sql
SQL
0 vote199 views1 answer
How to put is null in where in clause
SQL
0 vote188 views1 answer
How to set sql_mode for a query in CI model
SQL
2 votes206 views2 answers
Mysql alter column default
SQL
-1 vote191 views2 answers
How to display top 50 rows?
SQL
1 vote190 views2 answers
Mysql current user
SQL
0 vote189 views1 answer
Multiple tricky query in sql server
SQL