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 votes118 views1 answer
Match in sql server
SQL
0 vote135 views1 answer
Mysql listing get a particu particular user firsdt
SQL
2 votes134 views1 answer
Sql server check for value in multiple columns
SQL
0 vote130 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote112 views1 answer
Dasebase_url-postgres for windows
SQL
4 votes163 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
7 votes117 views3 answers
How ot change name of column mysql
SQL
0 vote143 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
10 votes79 views1 answer
Oracle view dependencies
SQL
9 votes130 views1 answer
Oracle get table schema
SQL