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

5 votes281 views2 answers
Sql constraint check value in list
SQL
0 vote259 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote274 views1 answer
Into operator in sql
SQL
0 vote259 views1 answer
Turnicate in mysql
SQL
0 vote261 views1 answer
Sql select inside select sub query
SQL
0 vote272 views1 answer
Drop index in sql
SQL
2 votes258 views1 answer
Query to find table size in oracle 12c
SQL
0 vote277 views1 answer
Mysql change innodb to myisam
SQL
0 vote273 views1 answer
Mysql wait_timeout
SQL
3 votes256 views1 answer
Mysql load sql from file
SQL