Sql function

Create Function Fn_ToplamaYap(@sayi1 int,@sayi2 int)
Returns int
As
Begin
Declare @toplam int
Set @toplam = @sayi1+ @sayi2
return @toplam
End

Create function syntax sql server

CREATE FUNCTION Fact (@parameter datatype)
RETURNS returndatatype
AS
BEGIN
--sql statements
    RETURN --whatever you want to return but of returndatatype from above
END

Function in sql

CREATE [OR ALTER] FUNCTION <FNAME> (@<PARAMETER NAME1><DATATYPE>[SIZE]
RETURNS <return PARAMETER / ATTRIBUTE /VARIABLE DATATYPE>
AS
BEGIN
<FUNCTION BODY / STATEMENTS>
RETURN <return PARAMETER/ATTRIBUTE/VARIABLE NAME>
END

Similar codes

0 vote110 views1 answer
Mysql check if lowercase
SQL
0 vote96 views1 answer
Where in clause tsql
SQL
27 votes118 views3 answers
Mysql show tables in database
SQL
0 vote103 views1 answer
Where date major today mysql
SQL
-1 vote104 views1 answer
Mysql order by on condition
SQL
0 vote115 views1 answer
Allow null in psql
SQL
1 vote107 views1 answer
Create email address from first and last name in sql
SQL
0 vote98 views1 answer
Postpresql relation not found
SQL
0 vote110 views1 answer
Postgresql list extensions
SQL
0 vote109 views1 answer
Postgresql delete limit
SQL