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.