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 vote228 views2 answers
Athena drop partition
SQL
0 vote199 views1 answer
Odd record sql query
SQL
0 vote207 views1 answer
On sql table data exists
SQL
0 vote212 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
3 votes202 views1 answer
APEX elapsed time
SQL
1 vote227 views2 answers
End mysql command
SQL
7 votes205 views1 answer
Oracle pagination query offset
SQL
0 vote293 views1 answer
How to find sql server name
SQL
0 vote262 views1 answer
Create table as select sql server error
SQL
62 votes508 views8 answers
Mysql add column
SQL