asked
I have a string. I want to generate a table from it
@STR = 'sadf dfd gf rgt fg rt tr ew' REQUIRED OUTPUT: sadf dfd gf rgt fg rt tr ew (i.e., columns(sadf dfd gf rgt fg rt tr ew) in a table )
do you want to generate and execute a `CREATE TABLE` statement using the characters in the string as column names? Where is the string generated - an application? How do you determine data types, null-ability, default constraints or primary key - a second string with control language or should the process "just know"? Maybe whatever method you are using to generate the delimited string could be modified to include the rest of the `CREATE TABLE` statement.
I need to use the results from this newly generated table in where clause comparision in a stored procedure. (i.e., SomeTable.ColumnName in (newly generated table.ColumnName))
So, something like: declare @CreateTable AS varchar(max) SELECT @CreateTable = REPLACE(@STR, ' ', ' nvarchar(max) NULL,') SELECT @CreateTable = @CreateTable + ' navarchar(max) NULL)' SELECT @CreateTable = 'CREATE TABLE TableName (' + @CreateTable + ')' exec @CreateTable (Untested, and not attempting to answer the question "Why?") What that does (or, rather, should do) is build a string in the following steps: * replace every space in the input string with a data type `(nvarchar(max) NULL)` and a comma at the end * adds the same again at the end (but without the comma this time) * pre- & appends those bits that are needed to round out the `CREATE TABLE` statement * executes it.
17 People are following this question.
