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

1 vote281 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
2 votes308 views1 answer
Sql as
SQL
-1 vote282 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
6 votes297 views1 answer
T-sql test if table exists
SQL
0 vote252 views1 answer
Now() -1 mysql
SQL
22 votes290 views4 answers
Tsql rename table
SQL
0 vote278 views1 answer
Default column value in sql same as other column
SQL
9 votes294 views1 answer
Sql server get utc date
SQL
0 vote295 views1 answer
Hex string sql becomes int64
SQL
0 vote307 views2 answers
How to install mssql on mac
SQL