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 2005 Forums
 Transact-SQL (2005)
 stopro return string?

Author  Topic 

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-09-15 : 23:46:00
do stopro return string?
CREATE PROCEDURE TEST AS BEGIN DECLARE @a VARCHAR(10) SELECT @a = 'aaaa' RETURN @a END GO EXEC TEST


Hope can help...but advise to wait pros with confirmation...

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-09-15 : 23:47:33
sorry stupid question


Hope can help...but advise to wait pros with confirmation...
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-09-15 : 23:51:59
yes.

Should use OUTPUT parameter instead.


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

waterduck
Aged Yak Warrior

982 Posts

Posted - 2009-09-15 : 23:59:28
ya...just remember that...forgotten


Hope can help...but advise to wait pros with confirmation...
Go to Top of Page
   

- Advertisement -