Kyle Witter
asked on
Add multiple rows of data in single SQL statement?
I have a table (User_Values) where I need to create 613 rows of data into columns "User_ValueKey" (primary key) and User_Values (int). The values are sequential, from 333 to 948. The data would look like this in the table itself
User_ValueKey User_Value
333 333
334 334
335 335
And so forth.
Is there a quick way to do this? I have SQL Server 2008 R2 Express, if that helps.
Thank you!
User_ValueKey User_Value
333 333
334 334
335 335
And so forth.
Is there a quick way to do this? I have SQL Server 2008 R2 Express, if that helps.
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Chris, this did exactly what I needed. Will definitely save this one for next time.
Open in new window