Rearming Windows Vista
Introduction
At work we have a Core 2 demo running Windows Vista. This demo is not connected to the network because we don't want people coming in and changing the background image to display something obscene or pornographic. There is a neat little trick that I found one day while trying to figure out how I could reset the time until the user had to activate Windows Vista.What to Do
When you log into Windows and your grace period has expired, you can still use Windows with reduced functionality. In reduced functionality mode, you are still able to use IE7.Subqueries and Merges
HTML Source EditorWord wrap Sub queries come in handy when you want to find a record but need to know what exactly to look for. For example, if you want to find all the items that are more expensive than a specific item. Instead of issuing two SELECT statements, you can use sub queries to find the answer in just one query.
Selected Single-Row Functions
A function is a block of predefined code. Single-row functions return only a single row for each record processed.
Group Functions
Group functions are also called multiple-row functions. These functions return a result for a group of rows that they process.
Restricting Selects and Sorting Data
When you select data, there’s a good chance that you’re looking for something specific. In using the SELECT statement you can attach a WHERE clause to limit the data that you are looking through. If you’re very good and know what you’re looking for then you can use the WHERE clause to find exactly what you want.
Joining Tables
Joining tables brings together data from two or more tables in one query in order to get all the information you need. There are six different types of joins:
|
Element |
Managing and Creating Users
Creating a user
Like table names and columns, a user name must follow the same rules. There is one minor difference. A user name can contain a dollar sign.
CREATE USER username [ IDENTIFIED BY password ] [ PASSWORD EXPIRE ]
SVCHOST Error on Logon
If you log on to the computer and you see a message like this:
svchost.exe -- application error the instruction at "0x745f2780" reference memory at "0x00000000". the memory could not be 'read'
Chances are that you have corrupted Windows Update data.
More Database Objects
A database object is anything that has a name and a defined structure. Other database objects that are used in Oracle 10g are sequences, indexes, and synonyms.