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 votes325 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote308 views1 answer
Sub query in linq
SQL
0 vote309 views1 answer
Oracle allow space to user
SQL
10 votes293 views1 answer
Dba_dependencies
SQL
0 vote290 views1 answer
Ms sql unique
SQL
1 vote301 views1 answer
Set mysql mode global query
SQL
-1 vote328 views1 answer
Round up and down sql
SQL
2 votes315 views1 answer
Change primary key sql
SQL
6 votes351 views4 answers
Mysql group by month
SQL
1 vote323 views1 answer
Load mysql dumb
SQL