July 15, 2013 at 12:26 am
Hi Team,
i want to generate Table with Data Scripts with Tasks > Generate Scritps,
but i dont to all the records, i want only few records scripts based on condition..
how to generate, Please suggest...
July 15, 2013 at 12:54 am
The tool generates all the data found in the table, so it's all or nothing.
Maybe you can create a duplicate table and insert into that table only the data that you want and then generate the scripts.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 15, 2013 at 9:45 am
Minnu (7/15/2013)
Hi Team,i want to generate Table with Data Scripts with Tasks > Generate Scritps,
but i dont to all the records, i want only few records scripts based on condition..
how to generate, Please suggest...
Use Tasks|Generate Scripts to create your 'CREATE TABLE' script WITHOUT data (or just right-click on the target table and 'SCRIPT TABLE AS...' Then use Tasks|Export Data which will let you enter a query based on your required filters to populate the new table as needed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply