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 vote148 views1 answer
What is between keyword used for
SQL
0 vote146 views1 answer
Stored procedures example
SQL
0 vote146 views2 answers
How to create a table from another table in sql derby
SQL
9 votes157 views2 answers
Convert data type in sql
SQL
0 vote140 views1 answer
How many columns can be used for creating index?
SQL
0 vote138 views4 answers
Sql year
SQL
6 votes135 views1 answer
Oracle trigger after connect
SQL
0 vote229 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
7 votes157 views2 answers
Where keyword sql
SQL
0 vote131 views1 answer
Sql view index
SQL