Software Enthusiast - KOY

Here's How : 1. Boot your computer to the Windows 7 DVD (or to a "Repair CD"). At this screen choose to install now. 2. Select your language and click next. 3. Click the button for "Use recovery tools". 4. Then select "Command Prompt". 5. When open, the command prompt will look like this: 6. The command we will use, bootsect.exe, is in a folder (named boot) on the DVD. We need to know what drive letter has been assigned the DVD drive to access the folder. Code: Type: diskpart and press Enter Type: select disk 0 (zero) and press Enter type: list volume and press EnterIn this screen shot, the 7 DVD is letter: G 7. Use your DVD drive letter and Code: Type: exit and press Enter to close Diskpart Type: G: (use the letter of your DVD drive) and press Enter Type: cd boot and press Enter Type: dir and press Enter to verify that bootcect.exe is there (if you really need to) 8. To restore the "boots...

MERGE Statement The MERGE statement can be used to conditionally insert or update data depending on its presence. This method reduces table scans and can perform the operation in parallel. Consider the following example where data from the HR_RECORDS table is merged into the EMPLOYEES table. MERGE INTO employees e USING hr_records h ON (e.id = h.emp_id) WHEN MATCHED THEN UPDATE SET e.address = h.address WHEN NOT MATCHED THEN INSERT (id, address) VALUES (h.emp_id, h.address); The source can also be a query. MERGE INTO employees e USING (SELECT * FROM hr_records WHERE start_date > ADD_MONTHS(SYSDATE, -1)) h ON (e.id = h.emp_id) WHEN MATCHED THEN UPDATE SET e.address = h.address WHEN NOT MATCHED THEN INSERT (id, address) VALUES (h.emp_id, h.address);

Have you ever wondered what kind of framwork or tools a particular web site is using? Well - there lots of tools out there that you can use to detect which framework or widgets are used by a website but the one I have found the most handy is - http://builtwith.com/ . Very neat and gives you a good idea of what tools a web site is based upon.