SQL Query Analyzer. How to display a column value?

[vikoch]

I am testing my stored procedure and I need to display a specific column value between the lines of my code. What command do I have to use?
Thanks

 

[PatriciaObreja]

Select ColumnName From TableName

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[vikoch]

Yes, I have a select statement.
But, I need to display what I selected from that column.

 

[PatriciaObreja]

Declare @a varchar(10)

Select @a = ColumnName from TableName
Print @a

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[AlexCuse]

Do you mean you want it accessible to your code? Or you want to read it, while you are reading your code (in comments)?

You might do well to read this:

http://www.tek-tips.com/faqs.cfm?fid=2244

Hope it helps,

Alex

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[vikoch]

Yes, I want to read it while I am reading my code (comments)
thanks.

 

[jbenson001]

/*Comment Here*/
OR
--Comment Here

 

[vikoch]

Thank you Patricia.