From SQL Team…We dealt with a recruiter question once before and had fun with it. This is the first recruiter question since then so I thought I'd give it a shot. I'll tell you how I came up with a solution built entirely on articles published on SQLTeam!

By Michael Otey The Microsoft .NET Framework promises to dramatically change the way you and I develop applications—including how we provide data access. ADO.NET, the next generation of ADO, will be the primary data access API for Microsoft .NET applications. If you already know ADO, you'll

In this article from SQL Server Magazine, Richard Waymire, lead program manager for SQL Server development at Microsoft, will answer several questions.

In this article, Garth discusses how to use access custom error messages generated by SQL Server with the Errors Collection of ADO. This is a follow up to the earlier Handling Errors in Stored Procedures article.

his unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter.

Enterprise application provider Made2Manage Systems Inc. announced at National Manufacturing Week the upcoming release of its new version 4.0 software product. Called the Enterprise Edition, Made2Manage 4.0 will feature the company's flagship Enterprise Resource Planning (ERP) product. The new s

SQL Server 2000 has claimed eWEEK's 2001 eXcellence Award for best enterprise systems development tool.

If you are an Access user, or migrated from Access to SQL Server, you may think that a primary key and an Identity/Autonumber column are the same thing. Well, they’re not, and there are some very good reasons NOT to use an Identity column for the primary key on your tables.

Welcome to RAC, the R(eplacement) for the A(ccess) C(rosstab) query, written exclusively for MS Server 7 and S2k. Use RAC to produce basic crosstab tables. Take advantage of the many computational and report type features to create more elaborate tables. Use RAC to perform various data manipulations

From SQL Team.com, Darrell writes "I need to figure out how to run a query and get a recordset row. With the data from that recordset I need to create create a new row changing the primary key. The old row then needs to have status fields updated. I hope that is clear." I'll discuss pass