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 vote303 views2 answers
Mysql missin expression near on
SQL
4 votes284 views1 answer
List tables sqlite
SQL
-1 vote311 views3 answers
MAKE TABLE FIT in oracle sql
SQL
3 votes293 views1 answer
Postgres count distinct
SQL
3 votes240 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
1 vote278 views1 answer
Sql dcl
SQL
0 vote264 views1 answer
Postgresql isnull with max
SQL
0 vote250 views1 answer
Create table employees oracle
SQL
1 vote270 views1 answer
Sql convert month name to number
SQL
1 vote274 views1 answer
How to update date add hours in postgresql
SQL