XML really makes it easy to move data from here to there and from there to here. However, eventually the data needs to be stored somewhere, most likely in a relational database. Here is how Edmond Woychowsky gets data from an XML document into a relational database.
2006-11-22
2,803 reads
How to Find Beginning and End of Week(for more scripts goto http://www.siccolo.com/articles.html)
2007-08-06 (first published: 2006-11-21)
1,145 reads
Create SQL Function To Format To Currency(for more scripts goto http://www.siccolo.com/articles.html)
2006-11-21
853 reads
To verify bank routing number by calculating correct check digit (digit #9 is used to validate 8-digit bank routing (ABA) number) and compare with digit #9 in given 9-digit routing number.(for more scripts goto http://www.siccolo.com/articles.html)
2007-08-03 (first published: 2006-11-21)
698 reads
To calculate bank routing check digit (digit #9 is used to validate 8-digit bank routing (ABA) number) (for more scripts --> goto http://www.siccolo.com/articles.html)
2007-08-02 (first published: 2006-11-21)
1,412 reads
This procedure is intended for single column primary key relationships.First we will create two table functions. The first finds a list of all tables with their primary key columns. The second finds all existing foreign key relationships with their table and column names. Finally we find all tables with primary key column names that do […]
2007-02-26 (first published: 2006-11-17)
974 reads
Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005.
2006-11-15
9,949 reads
Most of us don't get to make hiring decisions, whether we're interviewing or helping to interview someone. However we often have input on new employees. Steve Jones brings us some thoughts on helping to make the hiring decision.
2006-11-02
6,325 reads
Damon Armstrong learned the hard way about the consequences of not having a clearly defined project scope or work contract
2006-10-27
3,089 reads
Script will create a sorted list of databaes and their recvoery model. I'm sure there is a more elegant way to do this, but this works in a pinch.
2007-07-23 (first published: 2006-10-26)
1,067 reads
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers