If you don’t know how to generate insert into scripts please read it. I’ll show you how you can do it using Sql Management Studio Express.
If you want to generate scripts with insert commands from existing table you can do it in this way:
In next step you have to choose database:
Now you have to set Script Data to True and you have to set other options (like Script Foreign Keys, Script Indexes etc.) to False
Now you have to choose table/tables:
And that is all 🙂 You should see the script on query tab. For example like this:
[sql]
USE [TemporaryDatabase]
GO
SET IDENTITY_INSERT [dbo].[TMP_TB_Dictionary] ON
INSERT [dbo].[TMP_TB_Dictionary] ([ttt_id], [ttt_name]) VALUES (1, N’First’)
INSERT [dbo].[TMP_TB_Dictionary] ([ttt_id], [ttt_name]) VALUES (2, N’Second’)
INSERT [dbo].[TMP_TB_Dictionary] ([ttt_id], [ttt_name]) VALUES (3, N’Third’)
INSERT [dbo].[TMP_TB_Dictionary] ([ttt_id], [ttt_name]) VALUES (4, N’Fourth’)
SET IDENTITY_INSERT [dbo].[TMP_TB_Dictionary] OFF
[/sql]