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

3 votes275 views1 answer
MySQL DELETE JOIN
SQL
0 vote305 views1 answer
Acutal month year
SQL
0 vote294 views1 answer
Sql remove non numeric characters
SQL
2 votes325 views1 answer
Mysql select true or false
SQL
4 votes280 views1 answer
Is there any command to change postgres password
SQL
12 votes262 views1 answer
How to change the value of a table in sql
SQL
10 votes272 views4 answers
Mysql one week ago
SQL
1 vote277 views1 answer
Show all event schedular on mysql
SQL
7 votes298 views3 answers
Postgresql dump and restore db
SQL
1 vote267 views1 answer
Select from one table where not on the other
SQL