Question: how to export sql server data as script?
Answer: Right-click on your database and select Tasks > Generate Scripts.
In the Generate and Publish Scripts wizard, select the "Select specific database objects" option.
Expand the "Tables" tree and select all of the tables you wish to export the scheme and data for, then click Next.