Right click to
database name >> Tasks >> Generate Scripts …
Choose table you want
to backup >> Next
Click
Advanced
At General category >> Types of data to
script: schema and data >> OK
Rename your script
file >> Next
Next
Finish
Open script file, the
result as:
