SQL Server 2000 تعلم الSQL سيرفر 2000 مع التنصيب

8/14/2019 SQL Server 2000 SQL 2000

1/41

com.a4cb.www

SQL SERVER)))) (((()))) ((((

com.a4cb.www

8/14/2019 SQL Server 2000 SQL 2000

2/41

com.a4cb.www

::::

::::20202020

::::

::::com.@yahoo1510matrix_dxm_

HTML&ASPVISUAL BASIC6SQL

SERVER2000

8/14/2019 SQL Server 2000 SQL 2000

3/41

com.a4cb.www

:

autorun.exe

8/14/2019 SQL Server 2000 SQL 2000

4/41

com.a4cb.www

8/14/2019 SQL Server 2000 SQL 2000

5/41

com.a4cb.www

next

next

8/14/2019 SQL Server 2000 SQL 2000

6/41

com.a4cb.www

yes

8/14/2019 SQL Server 2000 SQL 2000

7/41

com.a4cb.www

8/14/2019 SQL Server 2000 SQL 2000

8/41

com.a4cb.www

next

finish

8/14/2019 SQL Server 2000 SQL 2000

9/41

com.a4cb.www

service manger

START / ALLPROGRAMS/MICROSOFT SQL SERVER /service manger

) (00

8/14/2019 SQL Server 2000 SQL 2000

10/41

com.a4cb.www

SQL SERVER

8/14/2019 SQL Server 2000 SQL 2000

11/41

com.a4cb.www

::::

::::20202020 ::::

::::com.@yahoo1510matrix_dxm_

8/14/2019 SQL Server 2000 SQL 2000

12/41

com.a4cb.www

HTML&ASP

VISUAL BASIC6SQLSERVER2000

SQL ServerSQL ServerSQL ServerSQL Server 2000200020002000

Star ---program---microsoft sql server---query analyzer

8/14/2019 SQL Server 2000 SQL 2000

13/41

com.a4cb.www

-- server manger

query analyzer windows authentication

sql server authentication ) (

8/14/2019 SQL Server 2000 SQL 2000

14/41

com.a4cb.www

8/14/2019 SQL Server 2000 SQL 2000

15/41

com.a4cb.www


))))SELECT statement((((

northwind , pubs

use

Use

SelectSelectSelectSelect statementstatementstatementstatement

selectselectselectselect *

fromfromfromfrom

8/14/2019 SQL Server 2000 SQL 2000

16/41

com.a4cb.www

SELECT column_name(s)FROM table_name

::::

use northwindselect * from employees

*

f5

use northwindselect firstname,lastname from employees

DISTINCT SELECT DISTINCT column_name(s)

8/14/2019 SQL Server 2000 SQL 2000

17/41

com.a4cb.www

FROM table_name

use northwind

select distinct firstname from employees


(where statment)

SELECT column FROM tableWHERE column operator value

=

> <

=

BETWEEN

LIKE

use northwindselect * from employees where firstname ='anne'

8/14/2019 SQL Server 2000 SQL 2000

18/41

com.a4cb.www

use northwindselect * from employees where employeeid > 3

use northwind

select * from employees where firstname like 'n%' n

use northwindselect * from employees where firstname like '%y'

y

use northwindselect * from employees where firstname like'%an%'

an


(INSERTstatment )

INSERT INTO table_name (column1, column2,...)VALUES (value1, value2,....)

LASTNAMEFIRSTNAME EMPLOYEES

INSERT INTO EMPLOYEES (FIRSTNAME,LASTNAME)VALUES ('MAHMOUD','ATIA')

8/14/2019 SQL Server 2000 SQL 2000

19/41

com.a4cb.www

open

INSERT INTO table1name (column1, column2,...)

8/14/2019 SQL Server 2000 SQL 2000

20/41

com.a4cb.www

SELECTcolumn1, column2,... from table2name

table1name table2name

SQLSQLSQLSQL ServerServerServerServer 2000200020002000

)(Update statment

UPDATE table_nameSET column_name = new_valueWHERE column_name = some_value

com.@yahoo1510matrix_dxm_

person

Person:

LastName FirstName Address City Nilsen Fred Kirkegt 56 StavangerRasmussen Storgt 67

8/14/2019 SQL Server 2000 SQL 2000

21/41

com.a4cb.www

UPDATE PersonSET FirstName = 'Nina'

WHERE LastName = 'Rasmussen'

LastName FirstName Address City Nilsen Fred Kirkegt 56 StavangerRasmussen Nina Storgt 67

nina person Rasmussen

personaddress=stien 12 lastname=rasmussencity=stavanger

UPDATE PersonSET Address = 'Stien 12', City = 'Stavanger'WHERE LastName = 'Rasmussen'

use pubsupdate titlesset price=5

8/14/2019 SQL Server 2000 SQL 2000

22/41

com.a4cb.www


))))delete statement((((

8/14/2019 SQL Server 2000 SQL 2000

23/41

com.a4cb.www

DELETE FROM table_nameWHERE column_name = some_value

person

Person:

LastName FirstName Address City Nilsen Fred Kirkegt 56 StavangerRasmussen Nina Stien 12 Stavanger

DELETE FROM Person WHERE LastName = 'Rasmussen'

LastName FirstName Address City Nilsen Fred Kirkegt 56 Stavanger

Truncate

Truncate table table_name

person

Truncate table person or delete * from person

8/14/2019 SQL Server 2000 SQL 2000

24/41

com.a4cb.www

LastName FirstName Address City

Drop Drop table table_name

person Drop table person


)Order By(

8/14/2019 SQL Server 2000 SQL 2000

25/41

com.a4cb.www

.

desc asc

.

use northwindselect firstname,lastnamefrom employees order by employeeid

use northwindselect firstname,lastname

from employees order by employeeid asc

8/14/2019 SQL Server 2000 SQL 2000

26/41

com.a4cb.www

use northwindselect firstname,lastnamefrom employees order by employeeid desc

8/14/2019 SQL Server 2000 SQL 2000

27/41

com.a4cb.www

asc desc

8/14/2019 SQL Server 2000 SQL 2000

28/41

com.a4cb.www


))))and or between((((

AndAndAndAnd

select * from employees where firstname='nancy'and lastname='davolio'

OrOrOrOr

'select * from employees where firstname='nancyor lastname='fuller'

8/14/2019 SQL Server 2000 SQL 2000

29/41

com.a4cb.www

And &orAnd &orAnd &orAnd &or

select * from employees

where( firstname='nancy' or lastname='fuller')and region='wa'

BetweenBetweenBetweenBetween SELECT column_name FROM table_name

WHERE column_nameBETWEEN value1AND value2

select * from employeeswhere employeeid between 1 and 3

8/14/2019 SQL Server 2000 SQL 2000

30/41

com.a4cb.www

select * from employeeswhere employeeid not between 1 and 3

8/14/2019 SQL Server 2000 SQL 2000

31/41

com.a4cb.www


)(alias

alias

SELECT column AS column_alias FROM table

select firstname as yourname,

lastname as famlynamefrom employees

8/14/2019 SQL Server 2000 SQL 2000

32/41

com.a4cb.www


)create(

CREATE TABLE table_name(column_name1 data_type,column_name2 data_type,.......)

1 use northwindCREATE TABLE Person(LastName varchar,FirstName varchar,Address varchar,Age int

) person ==northwind lastnamefirstname

address varchar int int

8/14/2019 SQL Server 2000 SQL 2000

33/41

com.a4cb.www

2CREATE TABLE Person

(LastName varchar(30),FirstName varchar,Address varchar,Age int(3))

lastname == 30 age 3

3use northwindcreate table newbooks(

bookid int identity(1,1) not null,

booktitle varchar(80) not null,

8/14/2019 SQL Server 2000 SQL 2000

34/41

com.a4cb.www

booktype char(12) not null constraint[booktupe_df] default ('undecided')pubcity varchar(50) null)

newbooks ==

bookid

Booktitle 80 not null

Book type char 12

undecided

Pubcity varchar 50 null

Varchar(10) 10

Char(10)

10 10

insert into newbooks (booktitle,booktype,pubcity)values ('mahmoud', 'mahmoud','mahmoud')

insert into newbooks (booktitle,pubcity)values ('mahmoud', 'mahmoud')

8/14/2019 SQL Server 2000 SQL 2000

35/41

com.a4cb.www

booktype

undecided

8/14/2019 SQL Server 2000 SQL 2000

36/41

com.a4cb.www


))))(Alter

Alter

ALTER TABLE table_nameADD column_name datatype

ALTER TABLE table_nameDROP COLUMN column_name

(ALTER TABLE employees add place varchar(30

ALTER TABLE employees drop COLUMN place

8/14/2019 SQL Server 2000 SQL 2000

37/41

com.a4cb.www

person

Person:

LastName FirstName Address

Pettersen Kari Storgt 20

cityALTER TABLE Person ADD City varchar(30)

LastName FirstName Address CityPettersen Kari Storgt 20

adress ALTER TABLE Person DROP COLUMN Address

LastName FirstName City

Pettersen Kari

8/14/2019 SQL Server 2000 SQL 2000

38/41

com.a4cb.www


(Function)

SELECT function(column) FROM table_name

use northwindselect sum(reportsto)from employees

function Max Min Sum Avg

8/14/2019 SQL Server 2000 SQL 2000

39/41

com.a4cb.www

GROUP BYGROUP BYGROUP BYGROUP BY............

SELECT column,SUM(column) FROM table GROUP BYcolumn

SALES

Sales tableCompany Amount

CDW 5500

IBM 4500

CDW 7100

SELECT Company, SUM(Amount) FROM Sales

Company SUM(Amount)

CDW 17100

IBM 17100

CDW 17100

SELECT Company,SUM(Amount) FROM SalesGROUP BY Company

Company SUM(Amount)

CDW 12600IBM 4500

MOUNT

8/14/2019 SQL Server 2000 SQL 2000

40/41

com.a4cb.www

HAVING...

SELECT column,SUM(column) FROM tableGROUP BY columnHAVING SUM(column) condition value

SELECT Company,SUM(Amount) FROM SalesGROUP BY CompanyHAVING SUM(Amount)>10000

Company SUM(Amount)

CDW 12600

Select nameof first column+name of second columnas new name of column fromname of table

USE NORTHWINDSELECT LASTNAME+''+FIRSTNAME FROM EMPLOYEES

USE NORTHWINDSELECT LASTNAME+''+FIRSTNAME as newname FROMEMPLOYEES

newname

8/14/2019 SQL Server 2000 SQL 2000

41/41

com.a4cb.www


)(select into

SELECT column_name(s) INTO newtable[IN externaldatabase]FROM source

person person_backup

SELECT * INTO Persons_backupFROM Persons

exec sp_help name_table

sql --

--*/

*/

a ba ba ba b

P b P b P b P b

SQL Server 2000 تعلم الSQL سيرفر 2000 مع التنصيب

Documents

Transcript of SQL Server 2000 تعلم الSQL سيرفر 2000 مع التنصيب