Treceți la conținutul principal

LIMBAJUL SQL

Table of Contents
Introduction 
1 Who Is the Teach Yourself SQL Book For?* 2 
DBMSs Covered in This Book * 2
Conventions Used in This Book *3
1 
Understanding SQL 5 
Database Basics *5 
What Is SQL? *.10 
Try It Yourself *.11 
Summary *12
2
 Retrieving Data 13 
The SELECT Statement *13 
Retrieving Individual Columns *14 
Retrieving Multiple Columns *16 
Retrieving All Columns *18 
Retrieving Distinct Rows *.19
 Limiting Results *20
 Using Comments *.23
 Summary *25
3 
Sorting Retrieved Data 27 
Sorting Data*27 
Sorting by Multiple Columns *29 
Sorting by Column Position *.30 
Specifying Sort Direction *.31 
Summary *34
4
 Filtering Data 35 
Using the WHERE Clause *35 
The WHERE Clause Operators *37 
Summary *42
5
 Advanced Data Filtering 43 
Combining WHERE Clauses *.43 
Using the IN Operator **47 
Using the NOT Operator *.49 
Summary *51
6 Using Wildcard Filtering 
53 Using the LIKE Operator *.53
 Tips for Using Wildcards *.60
 Summary *60
7 
Creating Calculated Fields 61 
Understanding Calculated Fields *61 
Concatenating Fields*62 
Performing Mathematical Calculations *68 
Summary *70
8 
Using Data Manipulation Functions 71 
Understanding Functions*.71
 Using Functions *73 
Summary *80
9 
Summarizing Data 81
 Using Aggregate Functions *.81 
Aggregates on Distinct Values *89
 Combining Aggregate Functions *90 
Summary *91
iv 
Sams Teach Yourself SQL in 10 Minutes
10 
Grouping Data 93 
Understanding Data Grouping *93 
Creating Groups *94 
Filtering Groups *96 Grouping and Sorting **99 
SELECT Clause Ordering *101 
Summary *.102
11 
Working with Subqueries 103 
Understanding Subqueries *103
 Filtering by Subquery**104 
Using Subqueries as Calculated Fields*108 
Summary *.111
12
 Joining Tables 113 
Understanding Joins **113 
Creating a Join *116 
Summary *.123
13 
Creating Advanced Joins 125
 Using Table Aliases*125 
Using Different Join Types *.126 
Using Joins with Aggregate Functions*132 
Using Joins and Join Conditions*134 
Summary *.135
14 
Combining Queries 137 
Understanding Combined Queries *137 
Creating Combined Queries*138 Summary *.144
vTable of Contents
15 
Inserting Data 145 
Understanding Data Insertion *145 
Copying from One Table to Another *.152 
Summary *.154
16 
Updating and Deleting Data 155 
Updating Data *155 
Deleting Data *157 
Guidelines for Updating and Deleting Data *160 
Summary *.161
17 
Creating and Manipulating Tables 163 
Creating Tables*163 
Updating Tables *.169 
Deleting Tables*171 
Renaming Tables *172 
Summary *.173
18
 Using Views 175
 Understanding Views**175
 Creating Views *179
 Summary *.185
19 
Working with Stored Procedures 187 
Understanding Stored Procedures *187
 Why to Use Stored Procedures *188 
Executing Stored Procedures *190 
Creating Stored Procedures*191 
Summary *.196
20 
Managing Transaction Processing 197
 Understanding Transaction Processing *197 
Controlling Transactions *199 
Summary *.204
vi 
Sams Teach Yourself SQL in 10 Minutes
21 
Using Cursors 205 
Understanding Cursors *.205 
Working with Cursors *207 
Summary *.211
22 
Understanding Advanced SQL Features 213 
Understanding Constraints *213 
Understanding Indexes *.220 
Understanding Triggers *.222 
Database Security *224 
Summary *.224

A Sample Table Scripts 225 
Understanding the Sample Tables *225 
Obtaining the Sample Tables *229

B Working in Popular Applications 233 
Using Apache Open Office Base*233 
Using Adobe ColdFusion *234 
Using IBM DB2*235 
Using MariaDB *235 
Using Microsoft Access*.235 
Using Microsoft ASP **236 
Using Microsoft ASP.NET *237 
Using Microsoft Query*238 
Using Microsoft SQL Server (including Microsoft SQL Server Express)*239 
Using MySQL *240 
Using Oracle*.241 
Using Oracle Express *241 
Using PHP *242
 Using PostgreSQL*243 
Using SQLite *244 
Configuring ODBC Data Sources *.245
viiTable of Contents

C 
SQL Statement Syntax 247
 ALTER TABLE *248 
COMMIT*248 
CREATE INDEX *248
 CREATE PROCEDURE**249
 CREATE TABLE *249 
CREATE VIEW *249 
DELETE *250
 DROP*250 
INSERT *250 
INSERT SELECT *.251 
ROLLBACK *251 
SELECT *252 
UPDATE *252

D 
Using SQL Datatypes 253 
String Datatypes*.254 
Numeric Datatypes *256 
Date and Time Datatypes *.257 
Binary Datatypes *258

E SQL Reserved Words 259
Index 265

Comentarii

Postări populare de pe acest blog

program principal cpp

#include "clasa.h" #include <stdio.h> #include <conio.h> #include <stdlib.h> #include <string.h> #define DELAY 9000000 void delay() { for(long i=0;i<DELAY;i++); } //constructor cu initializare de la tastatura BigInt::BigInt() {char x; signed char t[400]; int i; printf("\nNumarul cu semn "); do s=getche(); while((s!='+')&&(s!='-')); n=0; do {x=getche(); t[n]=x-'0'; n++; } while((x>='0')&&(x<='9')); n--; for(i=0;i<n;i++) nr[i]=t[n-i-1]; } //constructor cu initializare prin parametri BigInt::BigInt(char semn,signed char numar[],int dim) {int i; s=semn; n=dim; for(i=0;i<n;i++) nr[i]=numar[n-i-1]; } //transform un int negativ in pozitiv int BigInt::Pozitiv(int x) {int a,vb; a=0; vb=0; while(vb==0) if((x+a)==0) vb=1; else a=a+1; x=a; return x; } //constructor dintr-un nr int obisnuit BigInt::BigInt(int x) {int i; if(x>=0) s='+'…

NUMERE PRIME ALGORITM C++

// NUMERE PRIME ALGORITM C++//  reediting from scratch //on this page is just the study for a next algoritm for generating the parime nr series like Fibonnaci or ....if possibile
BPN = 2 POW 74207281 -1

odd impar
even par

!!! any even number is a sum of two even numbers or two odd numbers or two prime numbers
!!! any odd number is a sum of a odd number and a even numbers
!!!  prime numbers can not be a sum of two prime numbers but will be a sum of a prime number and an even number 
!!! any prime numbers will be odd too but not all odd number are primes
!!! all the numbers formed by same digit  1,3,7,9 are not prime numbers except 11


0, 1, 2, 3, 5, 7, 11, 13, 17, 19, 23, 29, 31, 
37, 41, 43, 47, 53, 59, 61, 67, 71, 73, 
79, 83, 89, 97

1 = 1 + 0+ 0              0
2 = 1 + 1+ 0              1
3 = 2 + 1+ 0              1

small numbers 

5 = 3 + 2+ 0              2
7 = 5 + 2 + 0              2
11 = 7 + 3 + 1            4
13 = 11+2 + 0            2
17 = 13 + 3 + 1 4
19 = 17 + 2+ 0 2
23 = 19 + 3 + 1 4
29 = 23 + 5 + …

o aplicatie php localitati romania

//APLICATIA SE REFERA LA BAZA DE DATE SIRUTA

//dragtable.js


/* dragtable v1.0 June 26, 2008 Dan Vanderkam, http://danvk.org/dragtable/ http://code.google.com/p/dragtable/ \Bsortabledraggable\B Instructions: - Download this file - Add <script src="dragtable.js"></script> to your HTML. - Add class="draggable" to any table you might like to reorder. - Drag the headers around to reorder them. This is code was based on: - Stuart Langridge's SortTable (kryogenix.org/code/browser/sorttable) - Mike Hall's draggable class (http://www.brainjar.com/dhtml/drag/) - A discussion of permuting table columns on comp.lang.javascript Licensed under the MIT license. */ // Here's the notice from Mike Hall's draggable script: //***************************************************************************** // Do not remove this notice. // // Copyright 2001 by Mike Hall. // See http…