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 votes201 views1 answer
Mysql cannot delete or update a parent row
SQL
-1 vote203 views1 answer
Condition in orderby mysql
SQL
0 vote219 views1 answer
Store case result sql
SQL
0 vote200 views1 answer
Power bi union columns
SQL
0 vote212 views1 answer
Mysql read row
SQL
1 vote201 views1 answer
Sql headers delphi
SQL
1 vote211 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote198 views1 answer
How to connect pgadmin with excel
SQL
0 vote236 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote232 views1 answer
Bitmap join index
SQL