Q : Dynamic SQL in sql server 6.5 
Author Message
 Q : Dynamic SQL in sql server 6.5

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 __.
----------------------------------------------------------------



Mon, 19 Jun 2000 03:00:00 GMT
 Q : Dynamic SQL in sql server 6.5

Asaf,

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

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



Mon, 19 Jun 2000 03:00:00 GMT
 Q : Dynamic SQL in sql server 6.5

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



Thu, 22 Jun 2000 03:00:00 GMT
 Q : Dynamic SQL in sql server 6.5

Steve,

Quote:
>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?



Roy



Fri, 23 Jun 2000 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Enabling TCP/IP server protocol BUG in SQL2K and SQL Server 6.5 native driver Qs

2. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

3. SQL Server 6.5 Dynamic SQL inside Trigger to Access deleted Table

4. transfer database from one SQL Server 6.5 to another SQL Server 6.5

5. Transfer database from one SQL Server 6.5 to another SQL Server 6.5

6. Great Plains Dynamics C/S+ running on SQL Server 6.5

7. Dynamic SQL Statement With SQL 6.5

8. Use of SQL Server 7.0 Client with SQL Server 6.5 Server

9. SQL Server 6.5 - Client Upgrade from SQL 6.0 to 6.5

10. Moving all databases from one SQL 6.5 server to another SQL 6.5 s erver

11. Transferring SQL 6.5 data base to another SQL 6.5 Server


 
Powered by phpBB® Forum Software