Contents tagged with SQL
-
SQL Server for developers: Improve Data loading performance using Bulk Insert & SqlBulkCopy
Every Developer ever worked with any kind of DB knows how to insert new rows into table. INSERT is one of the basic DML statements in SQL. For example, if we have a table with 3 columns (ID which is IDENTITY column, an int column and a text column) our INSERT statement will be something like this:
-
Generating SQL Backup Script for Tables & Data from any .NET Application using SMO
SMO, SQL Server Management Object, is a collection of objects that includes all you need to manage SQL Server from .NET applications. With SMO you can manage pretty much everything – from databases, tables, stored procedures, jobs – you name it.