32

32



File Edit View Query Project i j.NewQuery ) Q| | C& S Ł& I

ISS8I Northwind


Debug Tools Window Community Help

!& | E? S ^ 14 £

▼ | f Execute ► ■ V ip -3-1 J


r%


»=- >=-    A:'


Object Explorer


Connect - Si Si T 3



□ (local) (SQL Server 10.0.1600 - ANT36\student) El D Databases

0 Dl System Databases 0 D Database Snapshots


^SQLQuery2.sql ...\student (53))* SQLQuery 1.sql...student (52))* □ SELECT *

FROH [Northwind].[dbo].[Employees]


▼ X


where Country <> 'USA'


a


CJDate

Northwind


0 L_J Database Diagrams 0 □ Tables 0 D Views 0 D Synonyms 0 D Programmability 0 D Service Broker 0 D Storage 0 D Security NorthwindPL NorthwindPOL 0 D Security 0 D Server Objects 0 D Replication 0 D Management 0 SQL Server Agent


ii


-►r1


3 Results | _j Messages |

| EmployeelD |

LastName

FirstName

Title

TitleOfCourtesy

BirthDate

HireDate

Address

Ci

J_II 5

Buchanan

Steven

Sales Manager

Mr.

1955-03-04 00:00:00.000

1993-10-17 00:00:00.000

14 Garrett Hill

L.

_2_| 6

Suyama

Michael

Sales Representative

Mr.

1963-07-02 00:00:00.000

1993-10-17 00:00:00.000

Coventry House Miner Rd.

L.

Jj 7

King

Robert

Sales Representative

Mr.

1960-05-29 00:00:00.000

1994-01-02 00:00:00.000

Edgeham Hollow Winchester Way

L.

±J 9

Dodsworth

Annę

Sales Representative

Ms.

1966-01-27 00:00:00.000

1994-11-15 00:00:00.000

7 Houndstooth Rd.

L.


iL


±1


Curren ▼

U

□ Aggreg

Cc

El.

00:0C

Fil

2012

N<

(local

Rc

4

St

2012

St

Open

3 Connec

Cc (local

3 Connec

Cc

"O-

o

o

o

Cc

2012

Cc

4

Cc

2012

Cc

Open

Di

(local

Lc

ANT3

St

(local

St

10.0.

SF

53


3 Query executed successfully.


(local) (10.0 RTM) ANT36\student (53) Northwind 00:00:00    4 rows


Name

The name of the ...


Ready 7 Start I


* AD AT A UFD (E:)


**] 5a.bmp - Podgląd obra... "J: Iab2x.pdf - Adobe Rea... Microsoft SQL Serv... 31 .brnp - Paint


Ln 3    Col 25

Fwd: ss - razor!991w... | ^ Kody.txt - Notatnik


Ch 25


INS


14:47



Wyszukiwarka

Podobne podstrony:
04ddg06 - ^Infou.imo - Asymetrix InfoModeler 2. File Edit View Dictionary Project Browse Arrange Pag
04ddg07 - ^Infou.wdd - Asymetrix InfoModeler 2. File Edit View Dictionary Project Browse Arrange Pag
File Edit View Query j. New Query Qj ^ Cłfeil Northwind Project Debug Tools Window Community He
Microsoft SQL Server Management Studio File Edit View Query i j.NewQuery
Xfigs09 Publishing - Microsoft Developer Studio - [authors : Query (pubs)] IIP File Edit View insert
Xfigs10 Publishing - Microsoft Developer Studio - [authors : Query (pubs) *] IIP File Edit View inse
Xfigs11 Publishing - Microsoft Developer Studio - [authors : Query (pubs) “] File Edit View insert P
Xfigs12 Publishing - Microsoft Developer Studio - [authors : Query (pubs) *] IIP File Edit View inse
Xfigs13 ublishing - Microsoft Developer Studio - [authors : Query (pubs) *] B00 IIP File Edit View
Ufigs01 vz> Query - Microsoft Developer Studio-Ifll x
Xfigs10 Publishing - Microsoft Developer Studio - [authors : Query (pubs) *] IIP File Edit View inse
File Edit View Project Debug Tools Window Community Help i New Query
Ffigs01 ShowString - Microsoft Developer Studio  B00 File Edit View insert Project Build Jools
Ffigs02 vz> ShowString - Microsoft Developer Studio-Ifll x
Ffigs03 ShowString - Microsoft Developer StudioB00 File Edit View insert Project Build Jools Window

więcej podobnych podstron