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 vote375 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
-1 vote362 views1 answer
How to reset autoincrement in sqlite java
SQL
1 vote263 views1 answer
Oracle compile schema
SQL
0 vote304 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote324 views1 answer
Sql bild in function
SQL
0 vote312 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
16 votes321 views6 answers
Mysql find and replace
SQL
18 votes304 views2 answers
Sql comments
SQL
0 vote367 views1 answer
Stored procedure function relation
SQL
0 vote328 views1 answer
Import sql inside hide sql
SQL