Say you have a column in a SQL Server table that allows NULL values. You want this column to be unique when it has a value other than NULL. What’s

SQL Server does not allow you to include the Order By clause in a view.To do this, consider using the following workaround: USE pubsGOCREATE VIEW AuthorsByNameASSELECT TOP 100 PERCENT *FROM

The standard delimiters for literal strings in SQL are single quotation marks (‘). By default, SQL Server reserves double quotation marks (“) as delimiters for database objects.The SQL Server ODBC

The standard way to compare a variable String to a constant is to use this syntax: if(myString.equals(“test”)){ doSomething();} However, if myString is null, a NullPointerException will be thrown. Instead, use:

When you invoke a synchronized static method, you obtain the lock associated with the Class object in whose class the method is defined.When you apply synchronized to instance methods and

When a class designer believes that an exceptional condition is recoverable, the checked exception should be thrown. But, many programmers (and I am guilty of this as well) tend to

Sometimes, you need to find the Browser in which an applet is loaded. This small bit of code can do the job: public void getBrowserInfo(){ String vendor = System.getProperty(“java.vendor.url”).toLowerCase(); browser

It’s not uncommon that ASP.NET applications have the need to use a personal .config file to write some runtime information. Since ASP.NET applications are not granted the permission to create

Writing a transactional COM+ component with VB.NET is as simple as applying the Transaction attribute to a class that inherits from System.EnterpriseServices.ServicedComponent: Imports System.EnterpriseServices< Transaction()> Public Class BankTransfer Inherits ServicedComponent

COM+ 1.5 (provided with Windows XP) has an interesting feature that is missing in COM+ 1.0: the ability to disable entire COM+ applications or just their individual components. You can

COM+ 1.5 has the ability to run any server application as a NT service, so that the application is up and running when the machine reboots, before any client makes

Having a VB6 component support a COM+ construction string requires that you implement the IObjectConstruct interface and its only method, Construct. The .NET ServicedComponent class implements this interface internally and

VB6 objects can’t be pooled under COM+, because they are apartment threaded. This restriction is void with VB.NET objects (and all .NET objects in general), because they are free-threaded. To

To write a function like swap(datatype1, datatype2) that will take any two datatypes in its parameter and swap their values, use function templates.For example, to implement a generic swap function:

In C/C++ header files, it’s often necessary to include the header files of sub classes or classes which are used. For example: #include “a.h”

In some situations, you may want a certain data member of two different objects to be identical. For example, suppose you are writing a graphics program that will render a

In common top-down C/C++ programming, the main() function is written first, and then the functions that it calls, and then in turn the functions those functions call. For relatively small

Tail recursion is a special way of writing recursion in C/C++, which minimizes the time and memory, this can be done just by storing the value of variable in some

‘ Return the array of IP addresses for the local host’ Note: Requires Imports System.Net’ Example:’ Dim ipa As IPAddress’ For Each ipa In GetLocalHostIpAddresses()’ Debug.WriteLine(ipa.ToString())’ NextFunction GetLocalHostIpAddresses() As IPAddress()

‘ Serialize an object to file in binary format’ It can handle types that the SOAP serialization can’t’ Requires:’ Imports System.IO’ Imports System.Runtime.Serialization.Formatters.BinaryPrivate Sub SaveBinaryData(ByVal path As String, ByVal o