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 vote106 views1 answer
What are the aggregate function in sql
SQL
0 vote122 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
1 vote116 views1 answer
Sql oracle update multiple rows
SQL
3 votes134 views5 answers
Sql select
SQL
1 vote115 views3 answers
Mysql Server Start
SQL
0 vote142 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote116 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote124 views2 answers
Raise notice in postgresql function
SQL
0 vote131 views1 answer
Get initial in sql
SQL
0 vote115 views1 answer
Postgres type equivalent to timespan c#
SQL