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 vote135 views2 answers
Mysql decimal remove trailing zeros
SQL
10 votes258 views4 answers
Mysql if else
SQL
0 vote131 views1 answer
How to declare variable date in mysql
SQL
0 vote135 views1 answer
Sql select all tables from database change url
SQL
0 vote124 views1 answer
Search In the Database using Text
SQL
0 vote156 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
4 votes168 views1 answer
Mysql delete last row
SQL
3 votes136 views2 answers
Sqlite print all column names
SQL
3 votes161 views1 answer
RENAME table pl sql
SQL
5 votes151 views1 answer
Oracle sysdate - 1 month
SQL