How to Generate Script From Database with Where Clause

Question

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