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

6 votes401 views3 answers
Psql show columns of table
SQL
10 votes406 views4 answers
Mysql if else
SQL
1 vote364 views1 answer
List all triggers in SQL Server
SQL
1 vote342 views1 answer
Varchar plsql
SQL
0 vote344 views1 answer
Find number of entries sql
SQL
1 vote383 views1 answer
Deleting database in sql
SQL
2 votes377 views5 answers
Eloquest how to select one specific column in database
SQL
2 votes366 views1 answer
SQL column name Postgre
SQL
4 votes335 views2 answers
How to count items with same name in sql
SQL
0 vote369 views1 answer
Pass array parameter to stored procedure c#
SQL