Home Forums SQL Server 2012 SQL 2012 - General Sql Server - Generate Scripts RE: Sql Server - Generate Scripts

  • July 15, 2013 at 9:45 am

    #1632539

    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.