ODBiC Discussion Board


RE: Stored Procedures, Max Steiner, 10-14-2006

try this one

by Gordon Hsu, October 14, 2006 21:28

I didn't use output so that I don't have this problem.  You can try this one:

CREATE PROCEDURE dbo.x_test @test_cnt int AS

DECLARE @test_val NVARCHAR(50)

if @test_cnt = 1 begin set @test_val = 'A' end else begin set @test_val = 'B' end

SELECT @test_val AS y

then:

<!--SQL x_test 1 --> $y$



Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.