SQL Server

简单实用SQL脚本
http://www.cnblogs.com/gaizai/archive/2010/04/09/1708102.html

批量处理数据
---------------------------------------------------------------------

SqlBulkCopy加了事务真的会变快吗？
http://www.cnblogs.com/parry/archive/2012/09/11/SqlBulkCopy_Transaction.html 

.net使用SqlBulkCopy导入数据（创建新表）
http://wangfu-02.iteye.com/blog/1485373

使用 Bulk Copy 将大量数据复制到数据库
http://www.cnblogs.com/zthsn/archive/2010/07/12/1775770.html

Bulk Insert命令详细
http://blog.youkuaiyun.com/jackmacro/article/details/5959321

C#100万条数据导入SQL SERVER数据库仅用4秒
http://www.cnblogs.com/isline/archive/2010/03/18/1688783.html

SQLServer BCP 导入导出数据
http://www.cnblogs.com/xiaogangqq123/archive/2011/09/30/2196727.html

使用bcp进行大数据量导出导入
http://www.cnblogs.com/gaizai/archive/2010/04/17/1714389.html

SqlBulkCopy 类 (System.Data.SqlClient)
http://msdn.microsoft.com/zh-cn/library/system.data.sqlclient.sqlbulkcopy.aspx

导入和导出大容量数据
http://msdn.microsoft.com/zh-cn/library/ms175937(v=sql.105).aspx

SQL Server 管理对象 (SMO)
---------------------------------------------------------------------

SQL Server 管理对象
http://msdn.microsoft.com/zh-cn/library/hh248032.aspx

create [table,column],alter column use SMO
http://www.cnblogs.com/yushaoye201314/archive/2013/04/21/3033857.html

SQL Server编程系列(1):SMO介绍
http://blog.youkuaiyun.com/zhoufoxcn/article/details/7574658

SQL Server编程系列(2):SMO常用对象的有关操作
http://blog.youkuaiyun.com/zhoufoxcn/article/details/7593135 

Microsoft自动生成脚本插件Microsoft.SqlServer.Smo.dll
http://blog.youkuaiyun.com/zzuqqiu/article/details/6966715

用SMO（sql server management object)生成创建表的脚本
http://www.cnblogs.com/geyunfei/archive/2010/05/13/1734339.html

Copy Database Schema and Data Using SQL Server Management Objects (SMO)
http://www.codeproject.com/Articles/26459/Copy-Database-Schema-and-Data-Using-SQL-Server-Man

Sharing transactions with an SMO Connection
http://stackoverflow.com/questions/16272818/sharing-transactions-with-an-smo-connection?rq=1

Using SMO to script out Object definitions from SQL server database in .net in Parallel loop
http://stackoverflow.com/questions/9596425/using-smo-to-script-out-object-definitions-from-sql-server-database-in-net-in-p?rq=1

转载于:https://www.cnblogs.com/tomcat8/p/3160605.html