The TSQL of CSV: Comma-Delimited of Errors

Posted by: Simple Talk, on 13 Apr 2012 | View original | Bookmarked: 0 time(s)

Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil creates a CSV version of AdventureWorks as a linked server....

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 402 | Hits: 5

Similar Posts

  • Validation - Part 3 - Server-Side more
  • Get SOLID: Single Responsibility Principle more
  • Back to CSV - Convert CSV text to Objects; via JSON more
  • Easily extend post-commit hook in Subversion using NAnt - email anyone? more
  • How to debug a stored procedure in your Sql Server 2005 more
  • Working with Shortcut Keys (Lisa Feigenbaum) more
  • Tip Jar: Concatenating A Delimited String more
  • Command-capable CheckBox with GridView more
  • Commands in Avalon more
  • Asynchronous command execution in .NET 2.0 more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD