{"id":1747,"date":"2013-06-13T05:08:51","date_gmt":"2013-06-12T19:08:51","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=1747"},"modified":"2013-06-13T05:08:51","modified_gmt":"2013-06-12T19:08:51","slug":"sql-server-csv-import-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/sql-server-csv-import-primer-tutorial\/","title":{"rendered":"SQL Server CSV Import Primer Tutorial"},"content":{"rendered":"
\"SQL<\/a>

SQL Server CSV Import Primer Tutorial<\/p><\/div>\n

Welcome to the SQL Server CSV Import Primer Tutorial.<\/p>\n

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time). Its primary query languages are T-SQL and ANSI SQL.<\/p><\/blockquote>\n

There is no doubt that SQL Server is a great database to use and that T-SQL is an excellent tool to learn and use in conjunction with the Visual Studio suite of Visual C++,C#,VB.Net and ASP.Net products, where its integration is brilliant. The integration is improved even more when you make use of Microsoft SQL Server Import and Export Data (32-bit) functionality, as this tutorial does, when we go through (the pretty easy) motions of importing CSV (comma separated data) data into a SQL Server database.<\/p>\n

The CSV data used is from GeoLite Free Downloadable Databases<\/a> for whom I give thanks, because, as we all know, interesting data is INTERESTING!!<\/a><\/p>\n

In the primer tutorial you can see Microsoft SQL Server Import and Export Data (32-bit) and Microsoft SQL Server Management Studio<\/a> 2008 R2 after a successful install, importing CSV data into the SQL Server database. Installs of SQL Server can result from a variety of paths, including during installs of Visual Studio (Express) .<\/p>\n

Link to SQL Server more information … via Wikipedia, from where quote above came<\/a>.<\/p>\n

A comma-separated values (CSV) (also sometimes also called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.<\/p>\n

A general standard for the CSV file format does not exist, but it is described in RFC 4180 fundamentally. Also the used character encoding is not specified but 7-Bit-ASCII is used as the lowest common denominator.<\/p><\/blockquote>\n

Link to Comma Separated Values (CSV) more information … via Wikipedia, from where quote above came<\/a>.<\/p>\n

Link to SQL Server “spiritual home” … via Microsoft, includes talk about (the recent) SQL Server 2012, and about download options<\/a>.
\nLink to SQL Server jobs done … SQL Server jobs done<\/a> … some of personal experience.<\/p>\n

This product includes GeoLite data created by MaxMind, available from
\n http:\/\/www.maxmind.com<\/a>.\n<\/p>\n

If this was interesting you may be interested in this<\/a> too.<\/p>\n