Passing a value out of a Stored Procedure

• actinicblue

  Mr or Mrs. 500

  Points: 575

  More actions

  August 30, 2001 at 12:02 pm

  #157924

  I've created this procedure to count the number of times a particular condition was met in a log file.

  CREATE PROCEDURE SP_SMTPSTATS AS

  DECLARE @test-2 AS INT

  SELECT @test-2 = COUNT (*)

  FROM smtpstats

  Where clienthost = "10.0.0.64" AND Operation = "Data" AND bytesrecvd > 200 AND bytesrecvd < 2000

  ??????????????NOW WHAT????????????????????????????

  GO

  Now I need to finish the procedure to pass the value of @test-2 to a single text box in an Interdev asp page. The code may be all wrong, or I may be going about this all wrong I'm just looking for the right direction.

• Sean Burke

  SSCommitted

  Points: 1504

  More actions

  August 31, 2001 at 1:11 pm

  #417899

  You need to specify an OUTPUT parameter in your Create Proc statement, and assign the value of @test-2 to it. The resulting value will then be available for the process that called the SP.

  Sean

• Ripple

  SSC Eights!

  Points: 857

  More actions

  September 5, 2001 at 8:36 am

  #417996

  You can also return the value back in a result set. There are pros / cons for using either an output argument or as a result set. Both work well. I usually make both available, using an optional parament '@select_ind'.

  - Brendan