Tip Bank

This tip is for SQL Server 7.0 or up. If you

Install and uninstall issues are some of the most common sources of calls to help desks. The following is a tip on an implementation strategy for software updates using InstallShield

When the DNS service has stopped, use this code to start it automatically. #! /bin/bashdns_pid=`ps -ax|grep “named -u named” |grep -v grep |awk ‘{print $2}’`if test “x$dns_pid” = “x” ;

Reading from the object variable is always slower than reading from the local variable. So, if you are reading from the object variable frequently, then save it in a local

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:

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

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

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.