Instalação de Programas, Internet,
Antivírus, Anti-Hacker, Micros Novos e
Aulas Particulares para iniciantes.
Home
|
Clip Art
|
Downloads
|
Search
Tutorials
3D Studio MAX
Animation
Asp
Autocad
Cartoons
Clip Art
Delphi
Dhtml
Director
Download
Dreamweaver
Fireworks
Flash
Icon
Java
JavaScript
LightWave
Linux
Maya
Perl
Photoshop
Php
Pov-Ray
Search
Sql
Visual Basic
Wap
Sql
Database Journal :
Keywords: scripts, SQL scripts, .sql, functions, query, Maintenance and Management, Index Management, Replication, Data Warehouse, Lock and Connection Management, Miscellaneous, Mail, Backup, Restore, TSQL Aids, SQL Server 6.x Scripts
Finding Similar Sounding Names using SOUNDEX :
The situation: you've got a database containing information about each employee in your company. You decide to provide a search interface, allowing fellow employees to search for information on their coworkers by their last or first names. The only problem? People are searching for terms like Mike, and no results are being returned because, perhaps, Mike's name is stored as Michael in the database. Urg. Ideally, you'd like to return results that sound like Mike, but how can you do this? Actually, it's quite simple with SQL Server's built in
SOUNDEX
option! Read on to learn more!
FluffyCat :
SQL that can be used with Access, DB2, Informix, mSQL, MySQL, Oracle, SQL Server, Sybase, or any other relational database that uses SQL.
Gentle :
Interactive SQL tutorial. SQL Server, Oracle, MySQL, PostgreSQL, DB2 and Access. SELECT statements including joins and functions.
Interactive SQL Server & XML :
Summary: This tutorial will show you the different methods of retrieving XML from SQL Server, how to control how the data is returned, and then discuss how to navigate through the returned results.
jWorkBook :
Contents: Overview, Setting up the System, Starting up and Logging on to the database, Creating a SQL Query, Saving the results into the spreadsheet, Selecting Columns, WHERE Clause, Logical Combinations (AND, OR, NOT), Ordering the Results (ORDER BY), Column Headings (AS keyword), LIKE Keyword, SQL Functions, IN Keyword, Using a cell as a Statement Variable, Working with Multiple Statements, Using Dates, Current Date, Date Calculations, SQL Calculations, Joining: Looking at more than one table, COUNT Clause, GROUP Clause, HAVING Clause, SQL Sub-Selects.
Mssqlserver :
Scripts: scramble password, defrag, reindex, dbcc, update stats, load data, find fkeys, find defaults, age data, backup, no primary keys, drop keys.
MySQL Tutorial :
Documentation sections: Introduction, Connecting to the server, Queries, Using databases, Import or export data.
PostgreSQL :
Para alguns pode parecer um assunto batido, mas esse é um artigo introdutório, voltado principalmente àqueles que conhecem pouco ou nada sobre o PostgreSQL, um SGBD objeto-relacional.
Red Hat Database :
SQL Guide and Reference - SQL Syntax, Data Types, Operators and Functions, Extending SQL, SQL Commands, SQL Key Words.
SQL Tutorial :
Chuo-Han Lee: SQL SELECT, DISTINCT, WHERE, AND OR, IN, BETWEEN, LIKE, ORDER BY, Functions, COUNT, GROUP BY, HAVING, ALIAS, JOIN, OUTER JOIN, UNION, UNION ALL, CREATE TABLE, DROP TABLE, TRUNCATE TABLE, INSERT INTO, UPDATE, DELETE FROM.
Temporary Tables :
Sqlteam: Database Design, Queries, Stored Procs, Performance, Administration, App Design, OLAP, Security, Installation, Import/Export.
Transactions in MySQL :
Webmonkey: Lesson 1: Transactions, ACID, MyISAM tables. Lesson 2: BDB, Gemini, InnoDB tables
W3Schools :
SQL Basic: Introduction, Select, Where, And & Or, Between, Distinct, Order By, Try It, Insert, Update, Delete, Count. SQL Advanced: Functions, Group By, Aliases, Join, Create, Alter.
Desenvolvido e Atualizado por
Beto - Análise de Sistemas
Tel: (013) 9771-7861
Seg. a Sex. das 9 às 21Hrs.
Praia Grande - SP
desde 1994
