MSSQL对表自动生成带insert语句的建表语句 博客分类： MSSQL SQL Server

Right Click database -> Tasks -> Generate Script.

["Introduction" page: click next]

"Choose Objects" page: click table name(s)

Set Scripting Options: click advanced -> Types of data to script , choose "Schema and data"

click finish