SQL Server Forums - print variable contents

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

Old Forums

CLOSED - General SQL Server

print variable contents

Forum Locked

Printer Friendly

Author

Topic

-Dman100-
Posting Yak Master

208 Posts

Posted - 07/04/2006 : 18:18:42

I have the following table which I want to display the output using print.

Here is my table:

dbo.press_releases
headline varchar(255)
description varchar(294)
content text
pr_date datetime
pdf varchar(255)
id int primary key

Using query analyzer I was trying the following statement to display the contents:

DECLARE @pr varchar(8000)

SET @pr = (SELECT headline, description, content
FROM dbo.press_releases
WHERE id = 11)

print @pr

Thanks for any help.

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts

Posted - 07/04/2006 : 18:25:25

You have to declare one variable for each column

select @hl = headline, @dc = description, @ct = convert(varchar(8000), content)
from dbo.press_releases
where id = 11

-Dman100-
Posting Yak Master

208 Posts

Posted - 07/04/2006 : 18:37:26

Thank you.

madhivanan
Premature Yak Congratulator

India
22460 Posts

Posted - 07/05/2006 : 04:15:30

or

If all columns are of varchar type, then

DECLARE @pr varchar(8000)

SET @pr = (SELECT headline+','+ description+','+ content
FROM dbo.press_releases
WHERE id = 11)

print @pr

Madhivanan

Failing to plan is Planning to fail

Topic

Forum Locked

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.