Occasionally as developers we need to copy the contents of a database table to another remote sql server that we cannot access. We can export an Excel spreadsheet and email that to our counter parts at the remote machine. Another option is to create a file of SQL insert commands that will transfer the data.
In Sql Server Management Studio right click on the database containing your table,
Select "Tasks/Generate Scripts"
Skip the intro screen and then select the table to export
Then select "Advanced" and set "Types of data to script" to be "Schema and data" (or only "Data" depending on your needs).
Select "OK" in the panel. Then enter a "File name:" and then "Next>".
Then select "Next>"
And then "Finish".
And now in your export file "~/Documents/scripts.sql" are the commands to create and fill your table.
/****** Object: Table [dbo].[MYPETS] Script Date: 7/28/2016 1:51:31 PM ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[MYPETS](
[Age] [int] NOT NULL,
[Animal] [char](10) NOT NULL,
[Name] [varchar](30) NOT NULL
) ON [PRIMARY]
SET ANSI_PADDING OFF
INSERT [dbo].[MYPETS] ([Age], [Animal], [Name]) VALUES (1, N'Dog ', N'Rover ')
INSERT [dbo].[MYPETS] ([Age], [Animal], [Name]) VALUES (82, N'Turtle ', N'Yurtle ')
INSERT [dbo].[MYPETS] ([Age], [Animal], [Name]) VALUES (5, N'Llama ', N'Rama ')