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 vote340 views2 answers
Sql update top 100
SQL
6 votes407 views1 answer
Oracle trigger after logon on database
SQL
0 vote337 views1 answer
T-sql check if data exists
SQL
0 vote396 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote414 views1 answer
Sql cursor example multiple columns
SQL
0 vote396 views1 answer
Pl sql disable trigger
SQL
2 votes391 views3 answers
Mysql pass command from command line
SQL
1 vote366 views1 answer
How to delay stored procedure execution in sql server
SQL
3 votes412 views2 answers
Savepoint in sql
SQL
0 vote304 views1 answer
Sqlalchemy filter relationship
SQL