Thursday, 22 August 2013

Generate string processing for on rows from some table

Generate string processing for on rows from some table

I've got table with columns and procedure to create SQL table:
DECLARE @SQLString NVARCHAR(MAX)
SET @SQLString = 'CREATE TABLE '+ @TableName +
'
( '+@Column1Name+' '+@Column1DataType +' '+@Column1Nullable +')
'
EXEC (@SQLString)
How can I build SQLString with nodes from SELECT from another table?

No comments:

Post a Comment