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 vote154 views1 answer
Inner join distinct
SQL
0 vote125 views1 answer
Postgresql newline character
SQL
0 vote143 views2 answers
Replace null with 0 in sql
SQL
0 vote130 views2 answers
Temp tables in sql server
SQL
0 vote141 views1 answer
Insert into select with group by
SQL
0 vote100 views1 answer
Mysql offset from bottom
SQL
1 vote129 views1 answer
SQL date part only of datetime
SQL
4 votes128 views1 answer
Oracle error line
SQL
0 vote109 views1 answer
Create bakupd database sqlserver
SQL
1 vote142 views1 answer
Mysql select from outside
SQL