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 vote336 views1 answer
Postgresql if else endif
SQL
4 votes350 views1 answer
Wildcard in sql
SQL
0 vote372 views1 answer
Prodection ready postgres database step by step
SQL
1 vote359 views1 answer
Name of today sql
SQL
-1 vote373 views1 answer
Pl/sql how to delete a trigger
SQL
2 votes332 views3 answers
Postgres remove foreign key constraint
SQL
1 vote363 views1 answer
Get create table query existing table mysql
SQL
0 vote352 views1 answer
Sql include rows with 0 values
SQL
1 vote333 views3 answers
Postgresql connect to database
SQL
0 vote362 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL