' in output of stored procedure

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

SQL Server Development (2000)

' in output of stored procedure

Author

Topic

lane0618
Posting Yak Master

134 Posts

Posted - 2002-05-20 : 12:15:46

How do i get the " ' " symbol (single quote) to appear in the output parameter of a stored procedure?

Thanks,
Lane

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-05-20 : 12:23:46

This is a tough one to answer with you saying, "Just put it there"


create proc usp_lane @quote char(1) out
as
select @quote = ''''
go

declare @blah char(1)
exec usp_lane @quote = @blah out
select @blah
go

Is there more to the question?

<O>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources