Hi all,
Does sql-server 6.5 supports dynamic sql ? Can I build a sql statement (a
select statement for instance) inside a stored procedure and then execute it
?

For example: Can I create a stored procedure that accepts (as parameters) a
table name and a list of columns, and then builds and executes a select
statement and returns a result set ?

Any help / reference to books or websites will be appreciated.

TIA
--
Asaf Yaffe
GreenSoft Management Systems
----------------------------------------------------------------
If you want to reply by e-mail: remove the __.
----------------------------------------------------------------

Asaf,

 Yes, just look up the EXEC command in the books-online.

 Neil Pike MVP/MCSE
 Protech Computing Ltd (MS Solution Provider)

Yes

Look in Books Online at the Execute statement

The limitation is that the batch is limited to 255 characters, which does
pose a bit of a problem sometimes.

Has anyone found a way around this limitation? apart from being extremely
creative with multiple batches?

--
Steve Wort

Steve,

Roy