使用SQLDMO将表中的数据转为insert语句并存储于*.sql文件生成格式：SET IDENTITY_Insert [FunctionInfo] ON
GO
INSERT INTO [FunctionInfo](AutoCode,sFunName,sPagePath,f_AutoCode,iSort,bSelected) VALUES (3,'系统配置','System/SystemSet.aspx',7,1,1)
GO
SET IDENTITY_Insert [FunctionInfo] OFF
GO
INSERT INTO [FunctionInfo](AutoCode,sFunName,sPagePath,f_AutoCode,iSort,bSelected) VALUES (3,'系统配置','System/SystemSet.aspx',7,1,1)
GO
SET IDENTITY_Insert [FunctionInfo] OFF
--------------------
http://www.programbbs.com/doc/341.htm网上找到的资料，你看看，有帮助没