A SQL Statement with the Resultset Flopped
I got a request from a developer the other day to produce a SQL statement with the resultset flopped. In other words, he wanted the rows to appear as columns
I got a request from a developer the other day to produce a SQL statement with the resultset flopped. In other words, he wanted the rows to appear as columns
Often, in code, you find yourself constraining values doing something like: if(val < MIN) val = MIN;else if(val > MAX) val = MAX; This simple template function will do that
To find out if the correct version of Java .exe is installed in a system, type the following at the command line: java -fullversion
Before J2SE 1.5, Java had primtive data types with wrappers around them, so programmers had to convert from one type to another manually: public void manualConversion() {int a = 12;Integer
Say you’ve got a function: void f1( int iData){cout
Sometimes you need to update or insert into a view. But say your view has multiple tables like the outemp view: create or replace view outemp asselect EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,dnamefrom emp e
With the release of Microsoft Visual Studio.NET, you can now set multiple breakpoints on a single line. Example 1: Breakpoints on expressions in the for loop statement: for (InitExpression; ConditionExpression;
Setting topmost forms is easier with .NET than with previous Windows languages, since you no longer have to refer to an API call. Simply setting the .topmost form property to
In his tip “Locking a File With the Perl Flock Function,” Steve Renaker’s example opens a file without specifying read or write. While this will successfully open a file for