Using SQL Server 2008:
We have a main database - MAIN. For monthly data extracts, I create new tables with relevant data in another database called EXTRACT.
I use SELECT INTO statements to create the tables in the EXTRACT database. How do I preserve the primary key constraints in the EXTRACT tables? Do I need to write separate queries to set them?
View Complete Post