Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create a table with 180+ fields?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
How to create a table with 180+ fields?
Environment versions
SQL Server:
SQL Server 2008 R2
Application:
Web
Miscellaneous
Thread ID:
01600848
Message ID:
01600848
Views:
87
Hi
I need to create a table with 2 character fields ( field1, field2 ) then fields of BIT type, default to 0 (false) , named
[0501], [0502] [0503].....and up to [1029], [1030], [1031]
Where 0501 represents May 1, etc... ( format mmdd)
Is there some way to program sql server to build this?

Thanks
Jaime
Why do programs stop working correctly as soon as you leave the Fox?
Next
Reply
Map
View

Click here to load this message in the networking platform