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 vote211 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote218 views1 answer
Sql server remove enter from string
SQL
1 vote255 views1 answer
Update substring in mysql
SQL
1 vote246 views1 answer
Mysql connect bash
SQL
0 vote217 views1 answer
Check psql validity function
SQL
0 vote217 views1 answer
How to count with except in psql
SQL
0 vote253 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote228 views1 answer
With_for_update sqlalchemy
SQL
3 votes221 views2 answers
Coalesce mysql
SQL
0 vote223 views1 answer
Duplicate value unique constraint mysql error
SQL