create table command with all parameters using Stored procedure

[tracmonali]

Hello,

I wish to write a create table command in stored procedure. The table name and all the fields (columns) of the table, which is created at run time, are passed as parameters to the stored procedure. I have seen blogs where only the tablename is passed as parameter to the stored procedure. All the column names are however fixed. Could I have some guidance in this direction?

Just a note: I am using ASP.NET, VB.NET as my GUI. I am accepting parameters from the user with the help of checkboxes. So if few check boxes have NULL ( unchecked) the parameters sent to stored procedure will vary.

 

[priyanks]

Hi tracmonali,

Just want to confirm you want to create a table or you want to insert values to an existing table via a stored procedure

 

[tracmonali]

just create a table. the fields (columns) along with the data types are decided at runtime.

no values are inserted

 

[priyanks]

Hi Tracmonali,
Yup, you can do that by using dynamic SQL. But the other way of doing that will be by using smoapplication. Have a look at the following article that will give an idea:

http://www.davidhayden.com/blog/dave/archive/2006/01/27/2775.aspx