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 vote159 views1 answer
How to display value of variable in mysql
SQL
2 votes229 views1 answer
Postgresql group by month and year
SQL
1 vote151 views1 answer
Sql group by error
SQL
0 vote151 views1 answer
T-sql update table variale
SQL
0 vote146 views2 answers
Postgres default user
SQL
0 vote163 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote153 views2 answers
Auto increment column in mysql query results
SQL
1 vote139 views1 answer
Error code 1175 mysql fix
SQL
1 vote154 views1 answer
Mysql list bigger table
SQL
0 vote150 views1 answer
Hive batch drop table
SQL