Is there a way to print some comments btw queries

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

General SQL Server Forums

New to SQL Server Programming

Is there a way to print some comments btw queries

Author

Topic

jeff06
Posting Yak Master

166 Posts

Posted - 2007-02-07 : 17:24:32

I use sql query analyzer

/*text msg 1 :This is table A */
select * from a
/*text msg 2*: This is table B */
select * from b

I want some results in text like

This is table A
name age
jeff 28
ff 17
--------

this is table B
comid name lot
23 ie 100
34 ibm 234
---------

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-07 : 17:29:36

[code]
print 'This is table A'
select * from a
print 'This is table B'
select * from b
[/code]

PoojaJ
Starting Member

10 Posts

Posted - 2007-02-08 : 00:16:37

Or if u want ur comment in the way the data appears in Table
Select 'This is table A'
select * from a
Select 'This is table B'
select * from b

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources