(David Clark) Though it’s not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. But once you start trying to use one o

(Rod Stephens) Loading a DataSet from a database requires much less code than building one inline, though the code is a bit more complicated. Program FromDB shows how you can load a DataSet from a database. Program FromDB uses the code shown in Listing 2 to load its DataSet. The program begins w

(Eric Landes) This article gives some ideas of how to use a widely available open source DAL. Besides the standard ideas of how to actually use LLBLGen, I’ll go over how to modify this in another part of the series. Data Access Layer (DAL) generators can cut time down when building your applic

Well here we are, the moment we have all been waiting for. The PDC has finally [come and gone], and with it so has Longhorn Pre-Beta build 4051. There are many new things in this build that are worth checking out as well as a few disappointments we’d like to express. The main goal of this tweak guid

This article is based on the assumption that the reader is familiar with the configuration for SQL Server 2000’s virtual root and associated virtual names for templates and schema. The virtual root and virtual names are set up through the Configure SQL XML Support in IIS utility. For additional info

You can store the Data Transformation Services (DTS) package in one of three places. The following code samples describe the three methods to obtain a list of packages for each storage method.

(Peter W. DeBetta) Sure, SQL Server has lots of features that make it easy to manage and administer. Sure, it’s a world-class relational database management system. Sure, Transact-SQL (T-SQL) is an easy-to-learn language. Yet despite these and other facts, many developers only have a cursory knowled

This article describes various methods that you can use to simulate a cursor-like FETCH-NEXT logic in a stored procedure, trigger, or Transact-SQL batch.

(Ken Henderson) Working from the assumption that the human brain learns by associating new data with what it already knows, we’ll spend this chapter building a base framework onto which we can assemble the knowledge conveyed by the remainder of the book. We’ll touch on the topics covered in the

If you need a temporary table to persist across non-nested stored procedures and then you want to drop the temporary table when you no longer need it, you can dynamically create permanent tables in your code. This article provides an example of this procedure.