Use Navicat to export partial data for a table in a SQL Server database executable script

Today you encounter the need to export some of the data from a table in SQL Server and then import the database into a formal environment. So I wanted to export the executable SQL script directly and then put it on a formal environment, and then use the Navicat tool to help export the executable SQL script.

The steps are as follows: Click Export

、

Then, select the SQL script file and click Next

Click the location you want to export--click Select All

Direct next--Next

After the export,, no table name, the small master himself added, time a little hurry, will not continue to see the reason

　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　The record points drip, though insignificant.

Use Navicat to export partial data for a table in a SQL Server database executable script