A Survey of Microsoft SQL Server 2000 XML Features
An oldy, but good basic look at XML and how it fits into SQL Server 2000.
2004-09-23
3,008 reads
An oldy, but good basic look at XML and how it fits into SQL Server 2000.
2004-09-23
3,008 reads
SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.
2004-09-20
13,021 reads
Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.
2004-07-27
30,516 reads
2008-01-04 (first published: 2003-09-26)
185,317 reads
Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.
2003-02-20
13,194 reads
In this short article by Jamie Voss, he shows you the data model behind much of his task tracking system and the reasoning behind it.
2002-10-17
7,122 reads
This article shows you how to take a shaped recordset and convert the results into XML all while preserving the shaped recordset hierarchy.
2002-08-08
5,902 reads
An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.
2002-07-22
9,135 reads
In this article by Jamie Voss, he shows the methodology he used to develop his task management database.
2002-05-20
6,361 reads
This article demonstrates the ability to use the XML DOM on the client-side browser.
2002-04-11
16,696 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Comments posted to this topic are about the item The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers