Thanks Karthik www.f5Debug.net
Regards, Sheo Narayan http://www.dotnetfunda.com
DECLARE @nTable INT, @Sql NVARCHAR(MAX) SELECT @nTable =1, @Sql ='CREATE TABLE TB_TABLE1(' WHILE(@nTable<=1025) BEGIN SELECT @Sql = @Sql + 'Col' + CAST(@nTable AS VARCHAR(4)) + ' INT,' SELECT @nTable = @nTable +1 END SELECT @Sql = LEFT(@Sql,LEN(@Sql)-1) + ')' EXEC(@Sql)
Msg 1702, Level 16, State 1, Line 1 CREATE TABLE failed because column 'Col1025' in table 'TB_TABLE1' exceeds the maximum of 1024 columns.
Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions
Thanks and Regards Madhu
Login to post response