how do i do this in SQL????

Morpheus

I need a stored procedure that takes in a string from VBA
and uses it to create a table,
i know how to write stored procedures and all that but i want something like this....


declare @mystring as string
@mystring = 'table name'
Create Table @mystring ( etc etc etc....



is this possible ???

bonkey

There is no technical limitation to prevent you from creating a table inside a stored procedure.

However, you cannot put @variable values into the CREATE TABLE statement like your example. At least, I'm pretty sure you can't....for the same reason you can't have a stored proc which allows you to do "select * from @myTable"

What you end up needing to do is to actually build a string which contains the CREATE TABLE statement, and which then use the EXEC function to carry out the operation.....

At that point, the Stored Procedure is really only additional overhead, and you end up needing to question why you're using it.

jc

mr_angry

Its pretty easy to do in VBA. I presume its at least possible in a stored procedure, although I've never tried it, so I wont comment!