How to create 500 columns programatically in SQL Server? [duplicate]

by

That table is really a very bad design. Anyway, here you have the code. It uses dynamic sql:

DECLARE @sql nvarchar(max)

SET @sql = N'CREATE TABLE TheMostStupidTableIHaveEverSeen(ID int, Name varchar(100)'
DECLARE @i int = 1
WHILE @i <= 598
BEGIN
    SET @sql = @sql + N', A' + CAST(@i AS nvarchar(4)) + N' int'
    SET @i = @i + 1
END
SET @sql = @sql + N')'
EXEC (@sql)

More Related Contents:

  1. Select distinct record from table and perform Sum of column (Pallats, Gross) of a duplicate row. And show that duplicate rows once [closed]
  2. Select top 10 records for each category
  3. What this query does to create comma delimited list SQL Server?
  4. Formatting Numbers by padding with leading zeros in SQL Server
  5. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  6. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  7. SQL Call Stored Procedure for each Row without using a cursor
  8. How to select the last record of a table in SQL?
  9. What’s the best way to capitalise the first letter of each word in a string in SQL Server
  10. SQL string comparison, greater than and less than operators
  11. Postgres Case Sensitivity
  12. Splitting the string in sql server
  13. How do I query for all dates greater than a certain date in SQL Server?
  14. Check If the string contains accented characters in SQL?
  15. Need to list all triggers in SQL Server database with table name and table’s schema
  16. Count based on condition in SQL Server
  17. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  18. Get previous and next row from rows selected with (WHERE) conditions
  19. Does Sql JOIN order affect performance?
  20. Best equivalent for IsInteger in SQL Server
  21. Syntax of for-loop in SQL Server
  22. Using tuples in SQL “IN” clause
  23. Why does ISNUMERIC(‘.’) return 1?
  24. Can SQL Server Express LocalDB be connected to remotely?
  25. SELECT max(x) is returning null; how can I make it return 0?
  26. How to return default value from SQL query
  27. Group consecutive rows of same value using time spans
  28. Conditional aggregation performance
  29. Why do SQL Server Scalar-valued functions get slower?
  30. SQL add filter only if a variable is not null

Leave a Comment