INSERT 1000 entries into a table with SQL
Is there a way using the INSERT command to insert 1000 entries into a table without manually typing each value. I want to create a table and INSERT 1000-1999 values as primary keys. Is there some sort of i++ statement I can put in the query?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
u need to paste the query in a new query window and run it
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER