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 vote329 views1 answer
Uncomment listen_address=localhost
SQL
4 votes340 views5 answers
Primary key
SQL
0 vote377 views1 answer
Acutal month year
SQL
0 vote353 views1 answer
Renombrar tabla mysql
SQL
0 vote344 views1 answer
Mysql to get column name in database
SQL
0 vote346 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote441 views1 answer
How to rename a database in tsql
SQL
0 vote344 views1 answer
Sql count null values in all columns
SQL
4 votes369 views1 answer
W3schools create table
SQL
7 votes345 views1 answer
Alter sequence set current value oracle
SQL