function in storeed procedure

[sridhar21]

hi to all

i am sridhar

i need a simple example for all type of function in stored procedure

thanxs

[shweta123]

Hi,
here is the example for functions in Sql

Create function functionname(parameter1 datatype1,parameter2 datatype2 out)
returns datatype
as

--Here comes your declaration and code part
Declare @v1 int;
set @v1=0;
return @v1
End

[Frinavale]

hi to all

i am sridhar

i need a simple example for all type of function in stored procedure

thanxs

Hi there Sridhar,

What language are you using?

Here is an example of a function using VB.NET and store procedures:

Public Function FooBar(ByRef newUserID as String, ByRef newUserPswHash) As Boolean
     Dim sqlcom As New SqlCommand
     Dim res As Boolean = False
     sqlcom.CommandType = CommandType.StoredProcedure
 
     'Indicating which store procedure to use by supplying the sqlcom.CommandText with the store procedure's name
     sqlcom.CommandText = "add_user"
 
     'Adding the parameters the store procedure is expecting
     sqlcom.Parameters.Add("@u_id", SqlDbType.VarChar, 15).Value = newUserID
     sqlcom.Parameters.Add("@u_passwordHash", SqlDbType.VarChar, 40).Value = newUserPswHash
 
     'Setting the sqlcom.Connection to a pre-defined connection
     sqlcom.Connection = Connection
 
     Try
          res = (sqlcom.ExecuteNonQuery()=1)
     Catch ex As Exception
          res = False
     End Try
 
     Return res
 
End Function
 

Hope this helps

-Frinny