This is an advanced solution to delete duplicate Rows from a table using the cursor: create table DupTable ( Field1 varchar(20))goinsert DupTable (Field1) select ‘A11111111’ UNION ALL select ‘B22222222’ UNION

BCP is a command line tool that allows you to obtain data quickly, whether that data is in or out of a database or tables. The script below uses an

Using the IDENTITY function, you can add a Record number to an existing table.For Example: select * from addresscity state zip contract——————– —– —– ——–Lawrence KS 66044 0Nashville TN 37215

To translate an error code to its verbal description, use the function strerror(). strerror() is declared in as follows: char * strerror(int errcode); The function takes an error code and

Applications that handle signals must distinguish between atomic and non-atomic datatypes. Reading or writing an atomic object is guaranteed to take one instruction. By contrast, accessing a non-atomic object may

System calls and Standard Library functions assign a zero value to the global variable errno to indicate success. In case of an error, they assign negative values to errno. On

C and C++ differ in their interpretation of an empty parameter list. In the following function declaration: void f(); // different meanings in C and C++ C++ treats f as

You can define a template member function in an ordinary class as follows: class C{public: template int func(T* p);};template int C::func(T* p){ return 0;} Note that Visual C++ doesn Related

The native VB6 Split and Join functions have highlighted a number of useful techniques, and VB5 and VB4 programmers can use this extended facility as well. This code emulates the

Several new properties associated with files were not available when the original VB file I/O statements and functions were designed. To easily access these new properties Related Posts Inside NuScale’s

Loading a combo/listbox is pretty easy, and determining what the combo/listbox Text property selects is even easier. But if you load a table that contains duplicate values, you might run

If your VB ActiveX DLL includes a non-modal form, you can Related Posts Apple Unveils Advanced MacBook Air with M3 ChipEnterprises Say Mobile Development Achieves Positive ROIDimming the Sun: Aerosol

‘ If INCLUDE is True or is omitted, return the last occurrence of a character ‘ in a group’ or -1 if SOURCE doesn’t contain any character among those listed

This method consists of creating empty rows and columns where an image will show through around a central cell that will contain the table’s content.To use an image as a

The result is a password script that won’t crumble as soon as the user views the page’s source. Here’s the code: Enter username: Enter password: Related Posts Valve to support

Preventing the document from being cached ensures that a fresh copy of the document will always be retrieved from the site, even during the user’s current session, regardless of how

You can remove underlining from all the links in your page by including the following lines in the tag of your HTML page: Related Posts Microsoft agrees to suspend CISPE

There is no Response object method that will redirect/forward a page visitor to another page after a specified amount of time.To achieve this you can use following two methods:1) Using

Eliminate any database connection logic from your ASP pages by implementing a simple VB component that wraps up the most common ADO functionalities and in conjunction with a UDL. 1.

You can change the given format into the required date format using the CONVERT Function. Here’s an example: companyid peo———– ———–104 1998-09-30104 1999-09-30104 1999-12-31104 2000-03-31104 2000-06-30104 2000-09-30104 2000-12-31104 2001-03-31104 2001-06-30104

It’s possible to send messages from one system to another system in an Intranet by using ‘xp_cmdshell’ extended stored procedure in MS SQL Server. The usage of this procedure can

A string contains Yes or No answers to a series questions. How do you count the number of correct answers and wrong answers?Here’s the code: DECLARE @TestResults varchar (120)SET @TestResults

public String toString(){ StringBuffer sb = new StringBuffer( 256 ); sb.append(“[Field Name] [Value] “); Class curr = this.getClass(); while(curr != null){ Field[] field = curr.getDeclaredFields(); for(int i=0; i

The basic difference between the “==” and the “equals” method is to compare the two entities on either side of the operator or the method. But when objects are compared,