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 vote223 views1 answer
Alter owner in PostgreSQL
SQL
3 votes185 views1 answer
Sql timestamp to date
SQL
1 vote191 views1 answer
How much every mysql database record takes from diskspace
SQL
3 votes289 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote215 views1 answer
Oracle date winter time
SQL
0 vote214 views2 answers
How to use aggregate functions in sql
SQL
1 vote205 views2 answers
Mysql remove first and last character from string
SQL
1 vote294 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote352 views4 answers
Stored procedure sql
SQL
1 vote203 views1 answer
Declare table variable
SQL