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 vote185 views1 answer
Mysql_union
SQL
4 votes190 views4 answers
What is primary key
SQL
0 vote204 views1 answer
Mssql + bit + in python orm
SQL
0 vote187 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote200 views1 answer
Will graphql replace sql
SQL
0 vote190 views1 answer
Export partttion and import in oracle
SQL
0 vote185 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote143 views1 answer
Oracle sql replace string in clob
SQL
2 votes198 views2 answers
Postgresql search all tables for column name
SQL
0 vote179 views1 answer
Zsh: command not found: mysql mamp
SQL