The Breakdown

SQL Server Common Table Expression Hierarchical Example

clock July 7, 2008 04:52 by author pjacobs
SQL Server 2005 provides a mechanism called CTE or Common Table Expressions for pre-loading data or setting up for later use.  It is really fast compared to pre-2005 which did not have such a feature. To illustrate I'll take some hierarchical data and load it into a CTE.  This would be a ... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,
Categories: SQL Server 2005 | Tutorials
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Bulk Loading XML into SQL Server 2005 using .NET

clock April 30, 2007 15:14 by author Brad.Merrell
With a number of clients, I have been provided a sample format for a transactions along with instructions to develop a process to load it into a database as quickly and painlessly as possible.  This usually comes with the requirements that the XML data file can have any number of records from 1... [More]

Currently rated 5.0 by 2 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:
Categories: .NET | C# | SQL Server 2005 | XML
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Search

Calendar

<<  August 2008  >>
SuMoTuWeThFrSa
272829303112
3456789
10111213141516
17181920212223
24252627282930
31123456

Archive

Tags

Categories


Blogroll

    Disclaimer

    The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    © Copyright 2008

    Sign in

    Powered by BlogEngine.NET 1.3.0.0 | Original Design by Arcsin, Adapted by RazorAnt