Currently browsing

July 24, 2012

MS-SQL IFF equivalent in Oracle

There are two ways for replacing IFF within Oracle/PLSQL. First Way: In Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement. The syntax for the decode function is: decode( expression , search , result [, search , result]… [, default] ) expression is the value to compare. search is the value that is compared against expression. …

Data Compression IN SQL Server 2008

Data Compression IN SQL Server 2008   In this article I am trying to illustrate the concepts of Database Compression on SQL Server 2008. It is only the concepts behind the compression only. For details level of learning you need to follow the MSDN or any MS Notes.   Where …

Wireless audio over 24 GHz

Wireless audio over 2.4 GHz Just before the summer my contact at Texas Instruments had the excellent idea to sent me a CC85XXDK-HEADSET development kit. This is a PurePath Wireless Headset Development Kit to evaluate the new wireless audio products from TI based on the CC85xx family of RF micro-controllers. …

How to resize the console window using C

How to resize the console window using C The code for resizing the console window is given below #include #include #include HANDLE wHnd; // Handle to write to the console. HANDLE rHnd; // Handle to read from the console. int main(int argc, char* argv[]) { // Set up the handles …