Generating Data From Script

SSMS -> Database Name -> Task -> Generate Script

Select object -> Next

Click on “Advanced” in the “Types of Data to Script” select “Data only”

Generated Script

USE [DB01]
GO
INSERT [dbo].[tblTable01] ([Col01], [Col02], [Col03], [Col04]) VALUES 
(1, 1, N'Test', N'Test')
GO