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

2 votes204 views2 answers
Postgres change owner of schema
SQL
3 votes165 views1 answer
Mysql UPDate with enner join
SQL
5 votes184 views1 answer
Ora-00054 find lock
SQL
8 votes180 views1 answer
Insert a select statement into a table
SQL
0 vote178 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote194 views1 answer
Sql convert unix time to date
SQL
0 vote189 views1 answer
Null column as zero in mysql
SQL
4 votes169 views1 answer
Oracle table statistics last analyzed
SQL
0 vote177 views1 answer
Mysql add root password
SQL
1 vote183 views1 answer
Oracle list data files
SQL