SQL Server Performance

problem with functions

Discussion in 'SQL Server 2008 General DBA Questions' started by ajitha08, Aug 26, 2009.

  1. ajitha08 New Member

    HI.......
    I have a stored procedure
    as follows:

    ALTER procedure [dbo].[sp_getImagepath_delimiter]
    @profile_id varchar(50)
    as
    declare
    @photopath varchar(max)
    begin
    select @photopath=photos from registration_partnerprofile where profile_id=@profile_id
    select photopath as 'Photo Path' from dbo.fn_imagepath(@photopath,',')
    end
    and i want to create a function as same as above but i m not able to create a function using the above statements.
    can anyone help me with this. pls i need urgent..
  2. Adriaan New Member

    Just like a procedure is created with a CREATE PROCEDURE script, a function is created with a CREATE FUNCTION script.
  3. ajitha08 New Member

    ok no need. i cleared ny doubt.

Share This Page