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

1 vote182 views3 answers
Union SQL
SQL
-1 vote143 views2 answers
On delete set default sql server
SQL
1 vote193 views1 answer
Get create table query existing table mysql
SQL
4 votes175 views3 answers
Create database in mySQL
SQL
0 vote193 views1 answer
Enable sql server full text indexing
SQL
1 vote189 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote182 views1 answer
SQL Hello, [firstname] [lastname]
SQL
1 vote181 views1 answer
Rails run native ssql query
SQL
1 vote353 views1 answer
Import sql file from laravel
SQL
3 votes142 views1 answer
If 0 return null else return query mysql
SQL