Click here to Skip to main content
15,667,281 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a table with 2,00,000 records.I need to move first 1000 records into another table with all keys and Index and constraints in that main table.
Updated 30-Apr-13 1:32am
Aarti Meswania 30-Apr-13 7:09am    
what do you mean by index?
and key is primarykey + Autoincrement in destination table?
Saranya Boopathi 30-Apr-13 7:21am    
Cluster Index and noncluster Index also created in destination table which are created in main table
abdussalam143 30-Apr-13 8:13am    
what do you mean by index? Identity column ? or some thing else
Prasad Khandekar 30-Apr-13 8:38am    
Have you considered using SQL Server Import Export Wizard ([^])

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900