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

2 votes255 views2 answers
Postgresql get table names
SQL
9 votes224 views3 answers
Sequence postgresql
SQL
0 vote233 views1 answer
Mariadb number format
SQL
0 vote350 views5 answers
Right join
SQL
1 vote238 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote252 views1 answer
How do you insert boolean to postgresql
SQL
1 vote231 views1 answer
Psql filed name alter
SQL
1 vote229 views1 answer
Crontab every month
SQL
3 votes247 views1 answer
Oracle list dates without weekends
SQL
0 vote188 views1 answer
Sql table to store status
SQL