Say you want to retrieve all of the authors whose last names started with an L, M, or S. Here’s the query: select au_lname, au_fname from authors where au_lname like

For inserting explicit values into the identity column of a table, IDENTITY_INSERT property is set to ON. Table tblName has got following fieldsCompanyID INT IDENTITY(1,1)CoName VARCHAR(75) And following the data:

When you work with XML documents loaded into an XmlDocument class, you often need to examine the contents of child nodes. The XMLDOM programming interface purposedly provides the ChildNodes property.

Suppose that your ASP.NET pages display contents read from database fields. Suppose also that some of those fields may contain URLs or email addresses. A typical example is when you

In the XmlNode class, that is the class that provides node functionality in an XMLDOM representation of an XML document, the SelectNodes (and the ancillary SelectSingleNode) method exploits the XPath

In the .NET Framework, the DataSet’s WriteXml method when used to create a DiffGram does not provide the capability to include schema information along with the data. This is more

Many ADO.NET classes, including DataSet, DataTable, and DataColumn, use the ExtendedProperties property to enable users to add custom information. Think of the ExtendedProperties property as a kind of generic cargo

If you use VB6 to write COM programs that raise errors, it seems impossible to continue after hitting one of them. However, the (almost undocumented) commands ALT+F8 and ALT+F5 let

Use this function to generate random strings that abide by certain criteria. It

You can change database passwords from within VB to control more of your application

Many VB projects need a database connection string. But there

IF statements can become quite long when you’re testing for multiple values. Using the IN expression can make them more readable.So, instead of typing: IF (@testvar = 1 or @testvar

Always use an enum instead of defines and always close the list with an additional count. This makes life simpler and helps the compiler.Instead of defines: #define TypeA 0#define TypeB

All you need is a simple class that asks your object for each known interface. Here’s the class QI: #include #include #include class QI : public std::stringstream, protected CRegKey{protected: virtual

Suppose you need to make multiple inserts (or updates or deletes) to a SQL Server database?for instance, inserting items in a shopping cart. In the past, you needed to loop

Instead of writing a string class that contains a (char *), why not write a string class with a fixed char array? Of course, it would be repetitive if you

Consider this code: class CA{//…};class CB{//…};CA * CB2CA(CB *pb){ return dynamic_cast(pb);} The CA and CB are totally unrelated classes and the CB2CA function seems to be completely useless. However, what

A sparse array saves memory by not allocating memory for elements that are not initialized or to which you don’t need access. They’re quite easy using the STL map.This example

Use the following code: #include void main(){ char name[15]; double salary; ofstream outFile(“FileName.txt”, ios::in); while (outFile){ outFile >> name >> salary; }}