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 votes315 views2 answers
Mysql interval 1 day
SQL
0 vote358 views1 answer
Finding leap year in sql
SQL
10 votes332 views2 answers
Mysql drop database if exists
SQL
18 votes316 views4 answers
Uninstall mysql ubuntu 18.04
SQL
10 votes338 views5 answers
Create table mysql query
SQL
0 vote299 views1 answer
Oracle gather table statistics
SQL
2 votes307 views1 answer
Get first 2 letter in sql
SQL
5 votes286 views1 answer
Oracle list packages
SQL
0 vote303 views1 answer
Knex last insert id mysql
SQL
4 votes292 views1 answer
Mysql biginteger size
SQL