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 vote100 views1 answer
How to remove default in mysql
SQL
0 vote109 views1 answer
Plsql check for string in numeric
SQL
3 votes133 views1 answer
What is having
SQL
0 vote100 views1 answer
Psql select * from table
SQL
1 vote114 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
49 votes167 views6 answers
Alter table add column
SQL
1 vote119 views1 answer
Retrieve meaning
SQL
0 vote101 views1 answer
Sql database connectivity
SQL
0 vote106 views1 answer
Display first three characters sql
SQL
13 votes102 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL