Use sp_procoption to execute a stored procedure automatically at the time of starting SQL server. The stored procedure that needs to be executed should be created in the master database

You should use the Cascading Style Sheets (CSS) visibility property to hide and show absolutely positioned elements. There is no need to use the CSS display property in the case

Many applications use an audible “beep” sound to signal that an error has occurred or to get the user’s attention for some reason. For example, a user interface that allows

There are various forms of friend declarations within a class template: a non-template friend, a specialized template friend, and a class template friend. A function template can also be declared

In C, it is valid to assign integers to an enumerated type. For example: /*** valid in C but not C++ ***/enum Status {good, bad};void func(){ Status stat = 1;

Question: Is there a parameter that can be used within a radio button tag in an HTML form to set the default value for the radio group? Answer: The CHECKED

In SQL Server 6.5, this command specifies that a distributed transaction managed by Microsoft Distributed Transaction Coordinator (MS DTC) starts and the transaction_name specifies a user-defined transaction name that is

The java.text.DateFormat class and its java.util.SimpleDateFormat subclass are useful for formatting and parsing date and time values. For example, your application may allow a user to enter a date value

While there is no way to specifically disable the back button from within the browser, you can shortcut the navigation to another page. The trick is to catch the onbeforeunload

Question: How can I make a Shockwave Flash movie run over or under a DHTML DIV tag with text inside? I tried to use z-index but it doesn’t work well

Question: I am working with Microsoft DHTML and when I insert the content of a field in a DHTML document, I lose part of my message. For example, suppose I

To enumerate all network-visible SQL servers using SQL-DMO objects, create a new standard EXE project and add a reference to sqldmo.rll. This file can be found in BinnResources1033sqldmo.rll under the

Visual InterDev 6, Service Pack 3 lets you switch your HTML tags to uppercase or lowercase in a flash. For example, if you want uppercase tags, highlight the section of

Here’s a nice little function that retrieves a list of the available serial ports on your system. Note that this function uses Java’s Communications API, also known as javax.comm, which

Private Declare Function GetWindowLong Lib “user32” Alias “GetWindowLongA” _ (ByVal hWnd As Long, ByVal nIndex As Long) As LongPrivate Declare Function SetWindowLong Lib “user32” Alias “SetWindowLongA” _ (ByVal hWnd As

Private Declare Function GetWindowLong Lib “user32” Alias “GetWindowLongA” _ (ByVal hWnd As Long, ByVal nIndex As Long) As LongPrivate Declare Function SetWindowLong Lib “user32” Alias “SetWindowLongA” _ (ByVal hWnd As

Private Declare Function GetTempFileName Lib “Kernel32” Alias _ “GetTempFileNameA” (ByVal lpszPath As String, _ ByVal lpPrefixString As String, ByVal wUnique As Long, _ ByVal lpTempFileName As String) As LongPrivate Declare

Private Declare Sub CopyMemory Lib “Kernel32” Alias “RtlMoveMemory” (dest As _ Any, Source As Any, ByVal bytes As Long)’ Returns an object given its pointer’ This function reverses the effect

DEFER is a relatively obscure attribute of the SCRIPT element, but if you want to enhance performance when authoring scripts, you can use it to indicate to Internet Explorer 4

Here’s an example of a better way to pass arguments to main() methods of Java classes than using String[] args. First, pass two named parameters, user and level, that come

A friend of a class template can be a function template or class template, a specialization of a function template or class template, or an ordinary (non-template) function or class.

You can declare a template specialization as a friend of a class template. In this example, the class template Vector declares the specialization C

A friend of a class template can be a function template or class template, a specialization of a function template or class template, or an ordinary (non-template) function or class.

A class template can be a friend of another class template. For example: template class D{/*

The New keyword in VB is used to create a new instance of a class as an object for use within the current application. When used in a component within

With the introduction of the Boolean data type in VB4, you might be tempted to convert it to a numeric value using the Val function for storage in a database

When dealing with numerics and strings, be advised of a couple “gotchas.” The Val() function isn’t internationally aware and will cause problems if you have users overseas. But you can’t

Instead of using an If construct to set a Boolean variable, you can assign a Boolean variable to the result of any logical comparison. For example, instead of this code:

Use the Count property to determine exactly how many controls are loaded. You can also use the For Each loop to perform code on each control. For instance, if you

Don’t overlook the UNION keyword in SQL as a way to simplify selections from multiple tables. For instance, to select the customer with the highest sales from three tables with