Use Bitwise Operators in T-SQL to do AND/OR/XOR (&/|/^) between two or more bit/integer variables. You can use z = x and y in VB where x,y,z is Boolean, in

Here’s the syntax for the stored procedure: CREATE PROCEDURE [dbo].[RenameColumn] @tblname as varchar(50), @oldcolnameas varchar(50), @newcolname as varchar(50)ASdeclare @tblColname varchar(100)set @tblColname = @tblname +’.’ + @oldcolnameBEGIN TRANSACTIONSET QUOTED_IDENTIFIER ONSET TRANSACTION

Suppose you have a String containing comma-separated substrings. In order to access the substrings individually, you’d normally rely on a StringTokenizer. And if you wanted to put the substrings in

The basic JTable rendering mechanism supports a single renderer for all cells in a column. The Column Renderer may be set in the TableColumn class. If the TableColumn Renderer is

Brackets are well balanced if each ‘(‘ has its ‘)’. The argument str represents the array of characters which contains the expression. The following function returns 0 if the brackets

In some cases, it is possible to call a class member function without creating the class object. In the following example, the program will print “hello world” although class A

If you need to output to the screen or print a long text string that has no spaces, the text string will not wrap to the preset dimensions of a

This code stops the annoying flicker often seen when you pack an object with data. Test this code with the controls that bother you most: Private Declare Function SendMessage Lib

If you put many TRACE’s, in your code, it might be very convenient to jump to each one of them by double clicking a text line in the Debug window.

These permissions are required for security reasons USE pubsGOCREATE PROCEDURE GeneralSelect @TableName SYSNAMEASEXEC (‘SELECT * FROM ‘ + @TableName)GO You probably expect that your stored procedure will make a call

When you write a new version of an API, you want to deprecate the old API. If you deprecate old API’s, the compiler will tell you wherever that deprecated API

‘ This macro routine makes VS.NET switch to the previously selected code editor ‘ / designer window, if it is still open. It is equal to opening the Windows ‘

‘ Creates a IIS virtual directory with the specified name,’ and that points to the specified physical path’ Note: requires a reference to the System.DirectoryServices.dll assembly’ Note: exception handling (for

‘ Resets the value for the input array of controls, and thier child controls’ Example:’ – reset all the controls on the form: ResetControls(Me)’ – reset specific controls: ResetControls(TextBox1, CheckBox1,

‘ Removes the IIS virtual directory with the specified name’ Note: requires a reference to the System.DirectoryServices.dll assembly’ Note: exception handling (for example to catch an invalid virtual directory ‘

‘ Returns an array of controls of the specified type,’ found within the specified parent control (or the form itself).’ Note: the search is optionally done recursively, by checking also