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 vote183 views1 answer
How to delete data from sql database in android
SQL
25 votes179 views6 answers
How to change column name in mysql
SQL
0 vote178 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote173 views1 answer
Import sql dump into postgresql database
SQL
1 vote177 views7 answers
Filter
SQL
0 vote175 views2 answers
Mysql add days to date
SQL
0 vote163 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
2 votes177 views2 answers
Postgresql search all tables for column name
SQL
0 vote179 views1 answer
SAP Return
SQL
0 vote173 views1 answer
Postgres type equivalent to timespan c#
SQL