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 vote145 views4 answers
How to connect form to database
SQL
0 vote179 views1 answer
Mysql wsrep ls
SQL
0 vote133 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote144 views1 answer
Pl sql disable trigger
SQL
1 vote137 views1 answer
Oracle split string
SQL
0 vote131 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote138 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote145 views1 answer
Mysql join same table multiple times group by
SQL
0 vote155 views4 answers
Open mysql port bitnami tomact
SQL
16 votes141 views3 answers
Delete row psql
SQL