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 vote247 views3 answers
Above average salary in sql
SQL
0 vote298 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
2 votes262 views1 answer
Guid to string sql
SQL
0 vote251 views2 answers
Null value in column violates not-null constraint
SQL
1 vote247 views2 answers
Sql select only row with the max date
SQL
12 votes251 views1 answer
Docker run mysql image
SQL
4 votes241 views1 answer
Oracle show errors compilation
SQL
0 vote246 views1 answer
Mysqldump don't drop table
SQL
0 vote263 views1 answer
SQL: calculate hours from two dates
SQL
0 vote250 views1 answer
Mysql date only no time
SQL