how to genrate a script using query only no other method

Question

May i know how to genrate a script using query only no other method

sonu kumar · Answer

Thanks for your answer u r right and i know this answer already my server object explorer is not working all the work we have tooo doo by the query not other method is applied pls if u know let me know and another known toooo

Riyaz Akhtar · Answer

Check out the below link for step by step process to generate the script: http://www.tech-recipes.com/rx/24277/sql-server-generate-insert-statement-script/

sonu kumar · Answer

Thanks for the reply I want to generate the database script so that i can transfer the amt the data into the another server the object Expoler is not working that server . every thing we had too every thing by query

Khan Abrar Ahmed · Answer

Hi what script you want to genrate form query can you please explain little bit more so we can understand.