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 vote165 views2 answers
How to set global time_zone in mysql
SQL
0 vote187 views2 answers
Postgresql gset
SQL
10 votes181 views1 answer
User_dependencies
SQL
11 votes177 views5 answers
How to install sqlite3 python
SQL
0 vote184 views1 answer
Drop procedure sql
SQL
2 votes196 views4 answers
2nd highest salary in mysql
SQL
1 vote192 views2 answers
Mysql between
SQL
0 vote288 views1 answer
How to show current database in mysql
SQL
0 vote207 views1 answer
In query in sql
SQL
5 votes245 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL