View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 08:25 PM
foldface@yahoo.co.uk
 
Posts: n/a
Default exec(select...), how supress the output?

Hi
I have a dynamically constructed sql query that I want to execute, e.g.
exec('select * from ' + @tablename)

(1) Can I suppress the output somehow if this returns no values?
(2) Can I use the result of this query in another query somehow? e.g.
select
(3) Can I control the size of the columns in the output somehow

Thanks
F
Reply With Quote