SSMS -> Database Name -> Task -> Generate Script
Select object -> Next
Click on “Advanced” in the “Types of Data to Script” select “Data only”
![](https://customersdb.blob.core.windows.net/org/1006/photo/f26523ad-d0ce-4b2d-8fe5-55a084188b3a.jpg)
Generated Script
USE [DB01]
GO
INSERT [dbo].[tblTable01] ([Col01], [Col02], [Col03], [Col04]) VALUES
(1, 1, N'Test', N'Test')
GO
Comments