2uzhan.com
Advertisement
Now Place:2uzhan.com » print results selected in begin-end blocks

print results selected in begin-end blocks

Microsoft SQL Server @ April 14, 2009   Views:0

How do I dsplay result set selected in

DECLARE @list= varchar(20)
BEGIN

SET @list= ''' + 'Blue' + ''' ',' + ''' + 'Green' + '''';
select name, charchetrstics, type
from my_table
where color IN ( @list)
END;

I execute it using sql managment studio,
it executes fine.

what statement to use inside begin-endblock so that it displays the result set selected by the select query.

print only works for single(scalar) vale...?

thank you

--------------Solutions-------------

Tags:
© 2018 2uzhan.com Contact