|
|
|
| Sql |
What is this? |
|
|
|
|
Database Journal
|
English - Script Categories for SQL Server 2000 / 7.x: Maintenance and Management, Index Management, Replication, Data Warehouse, Lock and Connection Management, Miscellaneous, Mail, Backup / Restore, TSQL Aids, SQL Server 6.x Scripts. |
|
FluffyCat
|
English - Select, Between, Group By, In and Not In, Joins, Delete, Insert, Update, Like, Order By, Subselect, Functions: Avg(), Count(), Count (Distinct), Max(), Min(), Sum() |
|
Gentle
|
English - create tables, indexes, views and other things, records into a table, adding, subtracting and formatting, create users, give them access, get at other peoples tables, find out what tables and columns exist, count and limit the rows return. |
|
Mssqlserver
|
English - Scripts: scramble password, defrag, reindex, dbcc, update stats, load data, find fkeys, find defaults, age data, backup, no primary keys, drop keys. |
|
Perl library
|
English - genquery.pl (Library); query.pl (Generate a query form); add.pl (Generate an add-record form); view.pl (Generate a full-record printout); update.pl (Generate a record-update form); delete.pl (Delete a record); create.sql (The database schema); drop.sql (To re-create your database) |
|
Red Hat Database
|
English - SQL Guide and Reference - SQL Syntax, Data Types, Operators and Functions, Extending SQL, SQL Commands, SQL Key Words. |
|
W3Schools
|
English - 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. |
|
jWorkBook
|
English - 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. |
|
