I was wandering if I could put a print inside a select or a select in a
print.

I know I can put a select inside another select which correlated subquires,
but is it possible to put a print inside another print, and if there are any
rules associated with this.

Any help would be appreciated.

Marc



--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDem

It makes no sense to "put a print inside another print". PRINT is not an SQL
statement. It is not used to query the database; instead it simply returns a
message, usually a user-defined string, to the client. Most developers use
the PRINT statement for testing/ debugging.

--
Anith

Marc (mnoon (AT) simtest (DOT) net) writes:
Have you the faintest idea of how that would look like? I haven't.
I just can't get it together. PRINT is a procedural statement, can have
that in anything else.

Why not try it?

PRINT (SELECT 123)

gives me:

Msg 1046, Level 15, State 1, Line 1
Subqueries are not allowed in this context. Only scalar expressions are
allowed.

Looks like the answer is no.

Again, how would that look like?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx