call proc in to proc and get value

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

call proc in to proc and get value

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-04-21 : 10:19:38

Chandresh writes "Hi,

Last two days I am working on this issue but I couldn't found any solution. I hope you help me...

Question:
=========
I wrote two procedure...

First
=====
CREATE PROCEDURE RStringVal
@mStr varchar(2) OUTPUT
AS
SET @mStr = "DispField";
GO

Second
======
CREATE PROCEDURE GetStringVal
@mTemp varchar(2)
AS
EXEC RStringVal @mTemp;
SELECT @mTemp;
GO

In second procedure @mTemp value shows null and i want to get 'DispField' text but I am not able to get this text so HOW CAN I SET THIS VALUE AND GET THIS VALUE.

Thanks in Advance."

kroky
Starting Member

14 Posts

Posted - 2004-04-21 : 10:31:29

CREATE PROCEDURE GetStringVal
@mTemp varchar(2)
AS
EXEC RStringVal @mTemp OUTPUT;
SELECT @mTemp;
GO

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources