SQL stands for Structured Query Language and was originally developed by IBM in the 70’s to interact with relational databases. It is the common language for databases, remains fairly readable and it is relatively simple to learn the basics (although the language can be very powerful).

Steps

1. 'SQL' is usually pronounced like 'sequel' but some people spell it out as 'S.Q.L.'
2. There are various dialects of SQL but most widely used database engines today adhere to the SQL99 standard from ANSI, and many vendors have implemented extra features to extend that standard (the Microsoft 'flavour' of SQL is called T-SQL or Transact-SQL).
3. Getting the Data Out! This is what it usually is all about. For this we use the SELECT statement; it will query or retrieve data from a SQL database.
4. A simple example would be something like: 'select * from tblMyCDList' which would get all columns (that's where the * comes in) and rows in the table 'tblMyCDList'.
5. Queries are usually much more complicated than this. The select can be used to tease out particular columns and rows out of a table and even link data from multiple tables or, for that matter, databases together.
6. If we want to filter the rows returned by the select statement, a where clause is needed to qualify the recordsets returned. 'select * from tblMyCDList where CDid = 27' will retrieve the rows where the field CDid is equal to 27. Or 'select * from tblAttribute where strCDName like 'Dark Side%' ' uses a wildcard representing zero or more instances of any character and will hopefully show that my collection does have my favourite Pink Floyd album.
7. INSERT and UPDATE statements are used to add and change data in a SQL database (check the links below for some excellent tutorials that can take you further).
8. The DELETE statement is used to remove data from a SQL database.

Tips

* It is very easy to attach to SQL databases from within Microsoft Access (it's query tool can be used in SQL mode although the syntax has differences from that used with SQL Server and other databases).
* Microsoft Query is a tool that comes with Windows – it has graphical or SQL query modes.
* Under Linux, the most popular databases are likely MySQL and PostgreSQL. If the console seems not convenient, use ExecuteQuery or some other similar open source tool.
* The following book may be helpful: Kline, Kevin, Daniel Kline and Brand Hunt. 2001. SQL in a Nutshell. 2nd Edition. O’Reilly & Associates, Inc.
* Use wamp or xampp an easier web server with phpmyadmin (mysql)




from wikihow

[+/-] Read more...

[+/-] Summary...

CCleaner(crapcleaner) is a useful tool for cleaning out accumulated internet or file waste. When reading this it is recommended that you read it through with the tips before deleting anything.

Steps

1. First open CCleaner
2. Go to the Cleaner tab and you will be confronted by a very confusing lineup of checkboxes.
3. To make this brief, below is my recommended setup:
4. Under internet explorer check temporary internet files, cookies, and last download location. Most users don't really need this stuff. keep history and bookmarks unchecked, history is a maybe, but you don't want to lose bookmarked sites. You can normally leave Windows Explorer, System, and Advanced alone.
5. Run CCleaner and it will start deleting files.
6. afterward it will present you with a list of the files deleted, you really don't need to go through it as it will be several pages long.
7. The registry cleaner is recommended for slightly more advanced users. Use it after uninstalling programs as they will often leave behind incorrect registry entries.
8. If you decide to run Registry cleaner then review the items detected and always back up the registry (I keep a folder aside for this)
9. The Tools tab lets you uninstall programs and set startup programs. Why do you need this if Windows has all of these features? Especially with Vista Home Ed. The windows defender software explorer( startup programs) doesn't pick up some entries (however software explorer is easier to use).
10. Using CCleaner to uninstall programs and then check for leftover registry entries takes less time.
11. Under Options you can determine how CCleaner cleans your files. I leave this alone.

Tips

* You might want to check the Recycle bin because CCleaner auto empties it.
* Make sure you aren't deleting needed files, press analyze before clean and backup the registry.
* Check the Applications tab under Clean as Firefox users might need to uncheck some of the options to prevent deleting history.

Posting from wikihow

[+/-] Read more...

[+/-] Summary...

1. If you bought a computer without an operating system rather than buying a copy of Windows XP or Vista, which can cost around $200, try an alternative operating system, like Linux or BSD. Ubuntu, Mandriva and Puppy are free and user friendly Linuxes.
2. If you bought a computer that has Windows installed but does not have Microsoft Office, try using OpenOffice.org. It can do everything Microsoft Office does, including opening and saving Microsoft Office file types.
3. Try an Open Source Software Distribution for Microsoft Windows such as OpenDisc, WinOSSCDRom, GnuWin, WinLibre, OSSCD, Kiaora or PortableApps for a USB stick.
4. Look around. Almost every software has a free alternative. Granted, some of them are more difficult to learn how to use than others, but sometimes it's good to learn something new, especially if doing so can save money.


Posting from wikihow

[+/-] Read more...

[+/-] Summary...

hought ain't it possible? It is. But it's a "little" typical.
Steps

1. Make a table with Alt+xxx combinations where xxx is a three digit number. This table will be a reference for you. Try all the way from alt+000 to alt+999. Keep this handy, preferrably in printed form.
2. Open an EXE file, probably, a small one. If you know C or C++, make a basic "Hello World!" program and open its EXE.
3. See what characters are used.
4. Open a new notepad file.
5. While referring to your table, go on entering the characters exactly as in the EXE you opened.
6. Save the file as a .EXE when you're done.
7. Run it.

Tips

* Prepare the table first before you start.
* Making a whole new EXE is not possible. You can only copy existing ones. To make an original EXE, learn a programming language.

[+/-] Read more...

[+/-] Summary...

USB (Universal Serial Bus) drives are now the thing to have! Say goodbye to CD-ROMs and those corruptive Floppy Disks, because they are in the past. Keep reading to learn how to make Windows detect a USB drive.

Steps

1. Make sure you are connected to the internet. Windows goes on the Internet through its database of drivers and will locate the correct driver for your computer.
* When you are connected to the internet, and you have an XP computer, a balloon will appear in the lower right hand corner and it will install itself.
* If you not connected to the internet, and cannot connect, then visit the manufacturer of your USB drives that does have internet access (e.g. friend's house, library).
2. Download the driver of the website, save it onto a disk, and bring the disk to your house.
3. Install the driver, and next time you plug in the drive, it should work.


Tips

* Reset your usb drivers that are not functioning correctly: Go to "device manager" by right clicking on "My Computer" from the start menu on the desktop. Then under the left side of this new screen choose "Device Manager" under "Computer Management". On the right side open up "Universal Serial Bus Controllers" right click on the one causing the problems and choose "Uninstall". Then choose "Ok" to remove the device. After, click on the white space in this same window then choose the icon at the top of the screen "Scan for hardware changes", this will scan and reload/install your corrupted drivers. At times you can remove all of the USB storage drivers with this method so that all drivers reset by the method above. (Do this at your own risk). Tip from eProvided USB Thumb Drive Recovery Company

Posting from wikihow

[+/-] Read more...

[+/-] Summary...