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 vote303 views1 answer
Check if a column is a primary key in sql server
SQL
8 votes274 views3 answers
Mysql alter table add index
SQL
17 votes283 views6 answers
Get last record in sql
SQL
8 votes309 views1 answer
Oracle search text in all packages
SQL
9 votes263 views2 answers
Default number in sql
SQL
3 votes296 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote300 views1 answer
Find how many tables in database sql query
SQL
-1 vote290 views1 answer
Condition in orderby mysql
SQL
0 vote275 views1 answer
Update set with inner join oracle
SQL
1 vote283 views1 answer
Sql query row number group by
SQL