(Gregory A. Larsen) In my first article in this series, I discussed how to store different statuses in a single integer column. In this article, I will expand on the topic of using integer columns for storing statuses and will discuss how to update the integer status column to change or remove a

(Chris Cathers) I am in a unique situation where I work. I ware two hats. Of course, I’m the local DBA doing everything SQL, from administration to development. But, I also ware the MCSE hat. As such, I often get asked many various things from my CIO. Everything from “Can you fix the email and give

When working with parameterized SQL Server stored procedures by using a data access technology such as ActiveX Data Objects (ADO), the members of the Parameters collection of the ADO Command object can be referenced by using either the name of the parameter or its numeric index into the Parameters c

(James Crowley) Trees can be an intuitively simply way of organising large amounts of information. We’re exposed to them everywhere – from directories in file systems and categories in a web directory to hierarchies in organisations and family trees! Something like XML handles hierarchical data well