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 vote331 views1 answer
Show table status command in mysql
SQL
0 vote335 views1 answer
Mysql changer nom table
SQL
6 votes365 views2 answers
How to get yesterday date in mysql
SQL
4 votes308 views2 answers
Select todays data postgres query
SQL
4 votes369 views2 answers
Oracle drop job
SQL
0 vote363 views1 answer
Arithmetic expression in sql
SQL
13 votes342 views2 answers
Sql count distinct group by
SQL
0 vote329 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
4 votes329 views2 answers
Mysql select where starts with
SQL
3 votes344 views3 answers
Sql last week
SQL