stored procedure with string return value, select via EXEC?

• petervdkerk

  SSCrazy

  Points: 2155

  More actions

  December 21, 2010 at 6:38 am

  #229721

  I have a stored procedure that generates a random string. I want to assign the result to a new variable @newstring, but am not sure how...

  I searched for storedprocs return values, but it seems to be only possible to return integer values.

  ALTER PROCEDURE [dbo].[_generateRandomString]

  @length int

  ,@validcharacters nvarchar(50)

  AS

  BEGIN

  ...

  END

  declare @newstring nvarchar(50)

  EXEC _generateRandomString 10, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'

• DB Dan

  SSC Veteran

  Points: 270

  More actions

  December 21, 2010 at 6:52 am

  #1265040

  You need to use an OUTPUT parameter.

  ALTER PROCEDURE [dbo].[_generateRandomString]

  @length int

  ,@validcharacters nvarchar(50)

  ,@randomstring nvarchar(50) OUTPUT

  AS

  BEGIN

  ...

  END

  declare @newstring nvarchar(50)

  EXEC _generateRandomString 10, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', @newstring OUTPUT

• petervdkerk

  SSCrazy

  Points: 2155

  More actions

  December 21, 2010 at 7:12 am

  #1265056

  Awesome! It works! 🙂