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 vote317 views1 answer
Mssql find deadlocks
SQL
-1 vote235 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote266 views1 answer
Connect to ssms with python
SQL
0 vote276 views1 answer
Drop database using terminal postgres
SQL
6 votes271 views2 answers
What is non relational database
SQL
0 vote279 views1 answer
Get last three characters in mysql column
SQL
4 votes243 views1 answer
SQL order random
SQL
0 vote214 views1 answer
Sql table to store status
SQL
0 vote309 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote279 views1 answer
How to copy data of a table from another database to table of anaother database
SQL