#bulk insert

T-SQL ile XML Data Import Etmek

Merhaba, bu yazımda T-SQL ile XML Data Import Etmek konusundan bahsedeceğim. Bildiğiniz zamanla XML kullanımı artıyor. Özellikle web servisler arasında XML çok popüler bir şekilde kullanılmaktadır. Bu yazımda sizlere bu XML verilerini nasıl tek seferde SQL Server’a import edeceğimizi göstereceğim.   T-SQL ile XML Data Import Etmek Bu yazıda sizlere XML verilerini Veritabanına import etme işlemini…

How to import CSVs from Azure Blob Storage to SQL Server 2017 ?

SQL Server 2017 introduces option to import CSV files stored in Azure Blog Storage

In this article we will see how to implement that step by step

Step 1: Create Database Master Encryption Key

This step is optional, if you already have created your database master encryption key, Please skip this

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'PleaseUseStrongPasswordHere'

Step 2: Create Database…

Quick and Easy Bulk Products Insert(with images) (OpenCart)

Purchase $15.00 Below is website credentials for demo : Admin User Name:- admin Admin password :- admin@123

Quick and Easy Mulitple Product Insert(with images)

======================================================================================== For those who has high volume of products to upload, its a huge task to upload products. In order to make it an easy and quick way we have this…

New Post has been published on http://www.varindersandhu.in/2011/05/17/sql-server-import-csv-file-to-sql-table-bulk-insert/

SQL Server – Import CSV file to SQL table - Bulk-Insert

Here is an example –  Import CSV file to SQL table using Bulk-Insert

CSV file means  Comma Separated Values file.

USE testdb GO CREATE TABLE table1 ( id INT, name VARCHAR(255), address VARCHAR(255) ) GO

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

Create CSV file in Shared folder on any remote location with name csv.txt

Suppose location of the file is \\dcc-566\Share\CSV.txt

Content of CSV file as :

Now let‘s Import this CSV file into Table1.

I found this very useful, when insert large data to SQL.

C#:

string xml = yourDataSet.GetXML();

All you do is pass this as a parameter to a stored procedure that I will mention below.

SQL:

Create Stored Procedure taking in a parameter of type XML.

Declare a variable that gets the handle for a prepared document created for SQL

Declare @docHandle int

The next two statements convert the input XML parameter into a format that SQL can handle.

EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDoc

EXEC sp_xml_removedocument @docHandle

In between the two statements is where we'll put a select statement to put the XML file into a temperory SQL table:

SELECT * into #tmpXMLTable

FROM OPENXML(@docHandle,'/RawFileDataSet/tblRawDropFile',2) 

WITH ( In here you put the column names along with column type to map your xml data to)

For more information on OPENXML please take a look at: