Generate script in SQL Server Management Studio
Here what you have to do:
- right click the database (not the table) and select tasks --> generate scripts
- Next --> select the requested table/tables (from select specific database objects)
- next --> click advanced --> types of data to script = schema and data
- next and finish
Use SSMS scripting feature (Rightclick on database->Tasks->Generate Scripts)
or
use SSMS Tools Pack