Hello Sir I have lots of data in to a table and do not want to generate whole data from table i want to generate only those data which is i need required like Select * Frin Table where Datayear='2016' so please guide me how to do beacuse if i generate whole table data then i get exception during generate script

whats the error? I feel that you are hitting the SSMS limitation check the TOOL menu--> Option--->Query Result

Mukesh, You can try database à tasks à Import Data --> [then choose source and destination] --> [write a query to specify the data to transfer] option à then write your query with filter [ where Id=12345]. Thanks.

Hello For generating script from db , there is a way like all data or nothing But you can try below link : http://agilebi.com/mcole/2011/04/04/how-to-generate-insert-scripts-for-existing-data/ Thanks