How to export database with data in MSSQL?
You can right click on the database in management studio.then go to,
Tasks --> Generate scripts --> Advanced
There you can enable "Type of data to script" as Schema and data
, then generate the script. So that your script file will be populated with your data in table.