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 vote313 views1 answer
Oracle select invalid views
SQL
3 votes323 views1 answer
Define REGEXP?
SQL
0 vote332 views1 answer
Luu ckeditor vao mysql
SQL
0 vote303 views1 answer
Hallo
SQL
0 vote353 views1 answer
C# mysql data reader from two tables
SQL
0 vote358 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote361 views1 answer
Trigger vérifier stock
SQL
7 votes323 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
26 votes335 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote336 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL