Microsoft SQL Server 2012 R2：单表导出
在数据库操作的过程中，单表导出 / 导入的操作是很常见的。
关于导出。
在Oracle中我们会使用：exp / expdp / rman 等工具实现。
在MySQL中，我们可以通过：mysqldump / xtrabackup / innobackup 等工具实现。
在MS SQL 2012 R2中，我们可以通过Management Studio实现。
具体如下：
首先，我们查看下我们希望导出的数据表：
可以看到，我希望导出的表是：
[DefaultWebApplicationDB-51a00d99-a914-487c-86a4-b7ec8e3d812a].[dbo].[UserInfo]
而上面的截图做了一个查询前1000行数据的操作。
开始导出：
注意，这个操作需要在表所在的数据库中操作。
如果希望导出单表，选择你需要的表。否则全库导出。
选择导出后文件的存放路径。
如果要选择导出表结构、表数据，或者全部？还需要点开“高级”做更详细的配置，如下：
这样，就导出成功了。
可以进入导出目录，查看下文件及其内容。
详细内容如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 |
USE [DefaultWebApplicationDB-51a00d99-a914-487c-86a4-b7ec8e3d812a] GO /****** Object: Table [dbo].[UserInfo] Script Date: 2016/8/18 13:56:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[UserInfo]( [tp_SiteID] [uniqueidentifier] NOT NULL, [tp_ID] [int] NOT NULL, [tp_DomainGroup] [bit] NOT NULL, [tp_SystemID] [dbo].[tSystemID] NOT NULL, [tp_Deleted] [int] NOT NULL, [tp_SiteAdmin] [bit] NOT NULL, [tp_IsActive] [bit] NOT NULL, [tp_Login] [nvarchar](255) NOT NULL, [tp_Title] [nvarchar](255) NOT NULL, [tp_Email] [nvarchar](255) NOT NULL, [tp_Notes] [nvarchar](1023) NOT NULL, [tp_Token] [varbinary](max) NULL, [tp_ExternalToken] [varbinary](max) NULL, [tp_ExternalTokenLastUpdated] [datetime] NULL, [tp_Locale] [int] NULL, [tp_CalendarType] [smallint] NULL, [tp_AdjustHijriDays] [smallint] NULL, [tp_TimeZone] [smallint] NULL, [tp_Time24] [bit] NULL, [tp_AltCalendarType] [tinyint] NULL, [tp_CalendarViewOptions] [tinyint] NULL, [tp_WorkDays] [smallint] NULL, [tp_WorkDayStartHour] [smallint] NULL, [tp_WorkDayEndHour] [smallint] NULL, [tp_Mobile] [nvarchar](127) NULL, [tp_MUILanguages] [varchar](64) NULL, [tp_ContentLanguages] [varchar](64) NULL, [tp_Flags] [int] NOT NULL, CONSTRAINT [UserInfo_PK] PRIMARY KEY CLUSTERED ( [tp_SiteID] ASC, [tp_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = ON, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 95) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[UserInfo] SET (LOCK_ESCALATION = DISABLE) GO INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'791f3e9b-81a1-40ae-a86a-427cf6c96174', 1, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313037, 0, 1, 1, N'i:0#.w|adamhuan\adamhuan', N'ADAMHUAN\adamhuan', N'', N'', 0xD3DC000001000000000000000100000005000000, 0x595532DD00000000CB020000EFEEEBEA03000000350000006E020000DFDEDBDA0000000000000000693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313130370F0000007C00000035000000B200000034000000E70000001C00000004010000180000001D0100000E0000002C0100002B000000580100000B0000006401000032000000970100001C000000B401000035000000EA0100001C00000007020000340000003C0200000E0000004B0200000F0000005B02000012000000633A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313130372C633A302A2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A30652E777C6164616D6875616E406164616D6875616E2E636F6D2C633A30232E777C6164616D6875616E5C6164616D6875616E2C633A30212E737C77696E646F77732C633A306B2E737C75726E2533616F66666963652533616964702533616163746976656469726563746F72792C633A30282E737C747275652C633A30252E637C73797374656D7C37626438393738662D316237362D343439332D383133642D3434393661343831313731312C633A306A2E737C6164616D6875616E406164616D6875616E2E636F6D2C633A30692E737C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313130372C633A306E2E737C687474702533612F2F31302E3135382E312E3135332C633A302B2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A302B2E777C732D312D312D302C633A302B2E777C732D312D352D31312C633A302B2E777C732D312D352D36342D31302C, CAST(0x0000A65B0030744C AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'791f3e9b-81a1-40ae-a86a-427cf6c96174', 4, 1, 0x633A30282E737C74727565, 0, 0, 1, N'c:0(.s|true', N'每个人', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'791f3e9b-81a1-40ae-a86a-427cf6c96174', 1073741823, 0, 0x010100000000000000000000, 0, 0, 0, N'SHAREPOINT\system', N'系统帐户', N'', N'', NULL, 0xA93540DD0000000034000000EFEEEBEA010000000C00000000000000DFDEDBDA0000000000000000010100000000000000000000, CAST(0x0000A66501003E0C AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 1, 0, 0x693A30292E777C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D353030, 0, 1, 1, N'i:0#.w|sharepointme\administrator', N'SHAREPOINTME\administrator', N'', N'', 0xD3DC000001000000000000000100000006000000, 0x510330DD0000000029030000EFEEEBEA0300000031000000D0020000DFDEDBDA0000000000000000693A30292E777C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D353030100000008400000031000000B600000031000000E8000000210000000A0100000E000000190100002B000000450100000B00000051010000320000008401000031000000B60100001C000000D301000031000000050200003200000038020000320000006B020000320000009E0200000E000000AD0200000F000000BD02000012000000633A30292E777C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D3530302C633A302A2E777C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D3531332C633A30232E777C7368617265706F696E746D655C61646D696E6973747261746F722C633A30212E737C77696E646F77732C633A306B2E737C75726E2533616F66666963652533616964702533616163746976656469726563746F72792C633A30282E737C747275652C633A30252E637C73797374656D7C37626438393738662D316237362D343439332D383133642D3434393661343831313731312C633A30692E737C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D3530302C633A306E2E737C687474702533612F2F31302E3135382E312E3135332C633A302B2E777C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D3531332C633A302B2E777C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D313030312C633A302B2E777C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D313030342C633A302B2E777C732D312D352D32312D3533353738373438362D39393736353630362D333435373137383434352D313030362C633A302B2E777C732D312D312D302C633A302B2E777C732D312D352D31312C633A302B2E777C732D312D352D36342D31302C, CAST(0x0000A659008F56EC AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 3, 0, 0x010500000000000515000000DE77EF1F664DF2054D5B10CEF4010000, 0, 0, 1, N'SHAREPOINTME\Administrator', N'SHAREPOINTME\Administrator', N'', N'', NULL, 0x83C22EDD00000000B4010000EFEEEBEA010000001C00000070010000DFDEDBDA0000000000000000010500000000000515000000DE77EF1F664DF2054D5B10CEF40100000E000000740000000700000090000000070000009C00000007000000B800000007000000D400000007000000F00000000F00000000010000070000001001000007000000200100000700000030010000070000003C01000007000000480100000700000054010000070000006401000060000000010500000000000515000000DE77EF1F664DF2054D5B10CE01020000010100000000000100000000010500000000000515000000DE77EF1F664DF2054D5B10CEE9030000010500000000000515000000DE77EF1F664DF2054D5B10CEEC030000010500000000000515000000DE77EF1F664DF2054D5B10CEEE03000001020000000000052000000020020000010200000000000520000000380200000102000000000005200000002E0200000102000000000005200000002102000001010000000000050200000001010000000000050B00000001010000000000050F0000000102000000000005400000000A000000010100000000001000300000, CAST(0x0000A65800A2E784 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 5, 1, 0x633A30282E737C74727565, 0, 0, 1, N'c:0(.s|true', N'每个人', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 10, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313038, 0, 0, 1, N'i:0#.w|adamhuan\zhaoyixiao', N'ADAMHUAN\zhaoyixiao', N'', N'', 0xD3DC000001000000000000000100000008000000, 0xA6C62EDD00000000D1020000EFEEEBEA030000003500000074020000DFDEDBDA0000000000000000693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313130380F0000007C00000035000000B200000034000000E70000001E000000060100001A000000210100000E000000300100002B0000005C0100000B00000068010000320000009B0100001E000000BA01000035000000F00100001C0000000D02000034000000420200000E000000510200000F0000006102000012000000633A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313130382C633A302A2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A30652E777C7A68616F79697869616F406164616D6875616E2E636F6D2C633A30232E777C6164616D6875616E5C7A68616F79697869616F2C633A30212E737C77696E646F77732C633A306B2E737C75726E2533616F66666963652533616964702533616163746976656469726563746F72792C633A30282E737C747275652C633A30252E637C73797374656D7C37626438393738662D316237362D343439332D383133642D3434393661343831313731312C633A306A2E737C7A68616F79697869616F406164616D6875616E2E636F6D2C633A30692E737C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313130382C633A306E2E737C687474702533612F2F31302E3135382E312E3135332C633A302B2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A302B2E777C732D312D312D302C633A302B2E777C732D312D352D31312C633A302B2E777C732D312D352D36342D31302C, CAST(0x0000A65800A7C088 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 11, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313039, 0, 0, 1, N'i:0#.w|adamhuan\zhaoxin', N'ADAMHUAN\zhaoxin', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 12, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313130, 0, 0, 1, N'i:0#.w|adamhuan\lipeng', N'ADAMHUAN\lipeng', N'', N'', 0xD3DC000001000000000000000100000008000000, 0x19C92EDD00000000C5020000EFEEEBEA030000003500000068020000DFDEDBDA0000000000000000693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313131300F0000007C00000035000000B200000034000000E70000001A0000000201000016000000190100000E000000280100002B000000540100000B0000006001000032000000930100001A000000AE01000035000000E40100001C0000000102000034000000360200000E000000450200000F0000005502000012000000633A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313131302C633A302A2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A30652E777C6C6970656E67406164616D6875616E2E636F6D2C633A30232E777C6164616D6875616E5C6C6970656E672C633A30212E737C77696E646F77732C633A306B2E737C75726E2533616F66666963652533616964702533616163746976656469726563746F72792C633A30282E737C747275652C633A30252E637C73797374656D7C37626438393738662D316237362D343439332D383133642D3434393661343831313731312C633A306A2E737C6C6970656E67406164616D6875616E2E636F6D2C633A30692E737C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313131302C633A306E2E737C687474702533612F2F31302E3135382E312E3135332C633A302B2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A302B2E777C732D312D312D302C633A302B2E777C732D312D352D31312C633A302B2E777C732D312D352D36342D31302C, CAST(0x0000A65800AA9F4C AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 13, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313131, 0, 0, 1, N'i:0#.w|adamhuan\liuchengjun', N'ADAMHUAN\liuzhijun', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 14, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313132, 0, 0, 1, N'i:0#.w|adamhuan\sunhuadong', N'ADAMHUAN\sunhuadong', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 15, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313133, 0, 0, 1, N'i:0#.w|adamhuan\test1', N'ADAMHUAN\test1', N'', N'', 0xD3DC000001000000000000000100000008000000, 0xF3AD36DD00000000C2020000EFEEEBEA030000003500000065020000DFDEDBDA0000000000000000693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313131330F0000007C00000035000000B200000034000000E7000000190000000101000015000000170100000E000000260100002B000000520100000B0000005E010000320000009101000019000000AB01000035000000E10100001C000000FE01000034000000330200000E000000420200000F0000005202000012000000633A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313131332C633A302A2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A30652E777C7465737431406164616D6875616E2E636F6D2C633A30232E777C6164616D6875616E5C74657374312C633A30212E737C77696E646F77732C633A306B2E737C75726E2533616F66666963652533616964702533616163746976656469726563746F72792C633A30282E737C747275652C633A30252E637C73797374656D7C37626438393738662D316237362D343439332D383133642D3434393661343831313731312C633A306A2E737C7465737431406164616D6875616E2E636F6D2C633A30692E737C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313131332C633A306E2E737C687474702533612F2F31302E3135382E312E3135332C633A302B2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A302B2E777C732D312D312D302C633A302B2E777C732D312D352D31312C633A302B2E777C732D312D352D36342D31302C, CAST(0x0000A65E00A5C2C4 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 16, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313137, 0, 0, 1, N'i:0#.w|adamhuan\jinhaitao', N'ADAMHUAN\jinhaitao', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 17, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313134, 0, 0, 1, N'i:0#.w|adamhuan\tiantian', N'ADAMHUAN\tiantian', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 18, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313136, 0, 0, 1, N'i:0#.w|adamhuan\qiaohai', N'ADAMHUAN\qiaohai', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 19, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313230, 0, 0, 1, N'i:0#.w|adamhuan\jinmingsheng', N'ADAMHUAN\jinmingsheng', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 20, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313138, 0, 0, 1, N'i:0#.w|adamhuan\shenyang', N'ADAMHUAN\shenyang', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 21, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313139, 0, 0, 1, N'i:0#.w|adamhuan\zhangliming', N'ADAMHUAN\zhangliming', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 22, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313135, 0, 0, 1, N'i:0#.w|adamhuan\wuliang', N'ADAMHUAN\wuliang', N'', N'', 0xD3DC000001000000000000000100000008000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 23, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313037, 0, 0, 1, N'i:0#.w|adamhuan\adamhuan', N'ADAMHUAN\adamhuan', N'dkseven_eli@163.com', N'', 0xD3DC000001000000000000000100000008000000, 0x32FB40DD0000000045030000EFEEEBEA0300000035000000E8020000DFDEDBDA0000000000000000693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D31313037110000008C00000035000000C200000034000000F70000001C00000014010000180000002D0100000E0000003C0100002B000000680100000B0000007401000032000000A70100001C000000C401000035000000FA0100001C00000017020000340000004C020000340000008102000034000000B60200000E000000C50200000F000000D502000012000000633A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313130372C633A302A2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A30652E777C6164616D6875616E406164616D6875616E2E636F6D2C633A30232E777C6164616D6875616E5C6164616D6875616E2C633A30212E737C77696E646F77732C633A306B2E737C75726E2533616F66666963652533616964702533616163746976656469726563746F72792C633A30282E737C747275652C633A30252E637C73797374656D7C37626438393738662D316237362D343439332D383133642D3434393661343831313731312C633A306A2E737C6164616D6875616E406164616D6875616E2E636F6D2C633A30692E737C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D313130372C633A306E2E737C687474702533612F2F31302E3135382E312E3135332C633A302B2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531332C633A302B2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3531322C633A302B2E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D3537322C633A302B2E777C732D312D312D302C633A302B2E777C732D312D352D31312C633A302B2E777C732D312D352D36342D31302C, CAST(0x0000A666005C3898 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'15872361931', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 24, 0, 0x010100000000000513000000, 0, 0, 0, N'NT AUTHORITY\LOCAL SERVICE', N'NT AUTHORITY\LOCAL SERVICE', N'', N'', NULL, 0xB5F830DD00000000DC000000EFEEEBEA010000000C000000A8000000DFDEDBDA0000000000000000010100000000000513000000070000003C000000070000004800000007000000540000000700000060000000070000006C000000070000008800000007000000980000000700000001010000000000010000000001010000000000050B00000001010000000000050600000001010000000000050F000000010500000000000515000000DE77EF1F664DF2054D5B10CEEE0300000102000000000005200000003802000001020000000000052000000021020000, CAST(0x0000A65A0023661C AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'1a989a80-dc8c-4df9-9b0c-4758ede5d6d1', 1073741823, 0, 0x010100000000000000000000, 0, 0, 0, N'SHAREPOINT\system', N'系统帐户', N'', N'', 0xD3DC000001000000000000000100000006000000, 0x3AFB40DD0000000034000000EFEEEBEA010000000C00000000000000DFDEDBDA0000000000000000010100000000000000000000, CAST(0x0000A666005C41F8 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'b1edef7b-5978-4b70-8e00-53b1f36d3049', 1, 0, 0x693A30292E777C732D312D352D32312D313231333038393935382D333830383836383232332D323633333938353839342D353030, 0, 1, 1, N'i:0#.w|adamhuan\administrator', N'ADAMHUAN\administrator', N'administrator@example.com', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'b1edef7b-5978-4b70-8e00-53b1f36d3049', 3, 1, 0x633A30282E737C74727565, 0, 0, 1, N'c:0(.s|true', N'每个人', N'', N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'b1edef7b-5978-4b70-8e00-53b1f36d3049', 5, 0, 0x010500000000000515000000DE77EF1F664DF2054D5B10CEF4010000, 0, 0, 0, N'SHAREPOINTME\Administrator', N'SHAREPOINTME\Administrator', N'', N'', NULL, 0xDEC12EDD00000000B4010000EFEEEBEA010000001C00000070010000DFDEDBDA0000000000000000010500000000000515000000DE77EF1F664DF2054D5B10CEF40100000E000000740000000700000090000000070000009C00000007000000B800000007000000D400000007000000F00000000F00000000010000070000001001000007000000200100000700000030010000070000003C01000007000000480100000700000054010000070000006401000060000000010500000000000515000000DE77EF1F664DF2054D5B10CE01020000010100000000000100000000010500000000000515000000DE77EF1F664DF2054D5B10CEE9030000010500000000000515000000DE77EF1F664DF2054D5B10CEEC030000010500000000000515000000DE77EF1F664DF2054D5B10CEEE03000001020000000000052000000020020000010200000000000520000000380200000102000000000005200000002E0200000102000000000005200000002102000001010000000000050200000001010000000000050B00000001010000000000050F0000000102000000000005400000000A000000010100000000001000300000, CAST(0x0000A65800A22628 AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) INSERT [dbo].[UserInfo] ([tp_SiteID], [tp_ID], [tp_DomainGroup], [tp_SystemID], [tp_Deleted], [tp_SiteAdmin], [tp_IsActive], [tp_Login], [tp_Title], [tp_Email], [tp_Notes], [tp_Token], [tp_ExternalToken], [tp_ExternalTokenLastUpdated], [tp_Locale], [tp_CalendarType], [tp_AdjustHijriDays], [tp_TimeZone], [tp_Time24], [tp_AltCalendarType], [tp_CalendarViewOptions], [tp_WorkDays], [tp_WorkDayStartHour], [tp_WorkDayEndHour], [tp_Mobile], [tp_MUILanguages], [tp_ContentLanguages], [tp_Flags]) VALUES (N'b1edef7b-5978-4b70-8e00-53b1f36d3049', 1073741823, 0, 0x010100000000000000000000, 0, 0, 0, N'SHAREPOINT\system', N'系统帐户', N'', N'', NULL, 0xA93540DD0000000034000000EFEEEBEA010000000C00000000000000DFDEDBDA0000000000000000010100000000000000000000, CAST(0x0000A66501003E0C AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'', NULL, NULL, 0) ALTER TABLE [dbo].[UserInfo] ADD DEFAULT ((1)) FOR [tp_IsActive] GO ALTER TABLE [dbo].[UserInfo] ADD DEFAULT ((0)) FOR [tp_Flags] GO |
关于导入。
如果希望导入，可以在需要导入的数据库中，执行上面通过导出生成的SQL脚本。
——————————————
Done。
