The IDENTITY_INSERT property allows explicit values into the identity column of a table. Only one session at a time is allowed to have the IDENTITY_INSERT property set to ON. If
function LPad(ContentToSize,PadLength,PadChar) { var PaddedString=ContentToSize.toString(); for(i=ContentToSize.length+1;I
Consider the following XML fragment: www.devx.com DevX Website Let’s say that you want to transform this XML in the following simple HTML code: DevX Website The most common way is
IP addresses logically are four numbers. While they are stored in the DB, they are usually held in only one field. I have encountered two types of such storage:1) VARCHAR(15)’;
Let’s say you have a table like this: ID test– —-1 Hello1 Mr.1 Gates2 I2 am2 the best And you want a result group by each ID: 1 Hello Mr.
You will often need to verify the correct running of your code. While you can use the debug mode of an IDE or compiler, you can also include some debugging
Most of us have the tendency to write: String s1 = “Hello”;String s2 = “World”;String s3 = s1 + s2; However, the above is an expensive operation. As Strings are
I have problems developing applications for non-English
It would often be convenient to store multiple values in the Tag property. Here are two simple functions that help you do that. The first function stores the value in