d. , , SQL Server. , .
4. Connection Properties ( ) Connect (). SSMS. - Visual Studio.NET (VS.NET), , SSMS . Microsoft , . . SQL Server .NET.
Object Explorer ( ), SSMS. , View | Object Explorer ( | ) <F8>. , .. , , , SQL Server. , SSMS ( Object Explorer () , , ).
Object Explorer ( ) , , Object Explorer Details ( ). . , . . . Windows, .
SSMS, View (). View (Object Explorer ( ) Registered Servers ( )) , . , , "" . , Registered Servers Types ( ), Database Engines ( Database Engines) Compact Engine (SQL Server Compact).
View.
Template Explorer ( ) . T-SQL. , , .
Solution Explorer ( ) , , T-SQL , .
|
|
Properties Window ( ) .
Bookmark Window ( ) , .
Toolbox ( ) , , , .
Error List ( ) , , .
Web Browser Web- SQL Server, SQL Server, .
Other Windows ( ) , T-SQL Query Editor ( ), .
Toolbars ( ) Query Editor ( ), Visual SourceSafe , .
Full Screen ( | ) , SSMS.
SQL Server , . Tools ().
Tools (), :
SQL Server Profiler ( SQL Server Profiler). , , SQL Server. , .., , SQL Server.
Database Engine Tuning Advisor ( ). . .
Options () SSMS. .
SSMS, , SSMS (. 2.10). , , Save ( ), , , , .
New Query ( ) , SQL Server.
New Query, New Database Engine Query ( ) . SQL Server.
New Analysis Service Query ( Analysis Service) .
Windows, . , Open ( ), T-SQL. , , Single Save SSMS. Multiple Save .
|
|
, . , Registered Servers Explorer ( ) , Object Explorer ( ), Template Explorer ( ) Properties ().
SSMS
, Tools () Options (). , SSMS .
Environment
, , Environment (), SSMS , . General (), Fonts and Colors ( ), Keyboard () Help (), .
Source Control
SQL Server (source control system) , . (plug-in). .
Text Editor
Text Editor ( ) , .
Query Execution
Query Execution ( ) , T-SQL. T-SQL SSMS SQL Server T-SQL.
Query Results
T-SQL SSMS. Query Results ( ) , .
1. , .
2. ? ?
3. SSMS?
4. .
5. ?
6. ? ?
7. Environment () Tools () Options ().
8. MDI ?
9. ? ?
10. ?
11. SSMS. .
12. , SSMS.
13. ?
14. sql server.
15. . ? ?
16. , : , , .
17. , : , , .
18. SSMS, MDI : , , .[1]
5
(QUERY EDITOR)
: .
:
1. ;
2. Query Editor.
Query Editor
, , Object Explorer ( ), T‑SQL. (free-form text editor), , . , SSMS (document view). Query Editor ( ), New Query ( ) File>New>Database Engine Query ( > > | ).
|
|
, . . SQL Server . SQL, .
. , ; ; .
, , . , , . , ( ), .
, . Execute () . , . , , . (grayed-out) , . , . , , , . , SQL Server "" .
T-SQL .
T-SQL , .. , View Designer ( ), .
. . , . .
. , , . , SQLCMD SQL.
, , . .
, , , , . , . .
|
|
T-SQL .
1.
test. :
create database test
.
2.
table_test , :
use test
go
create table table_test (col_test char(10))
.
3.
, :
INSERT INTO [test].[dbo].[table_test]
([col_test])
VALUES
(' '),
(' ')
GO
.
4.
, . :
SELECT [col_test]
FROM [test].[dbo].[table_test]
GO
.
.
Microsoft SQL Server 2008 (SSMS), T‑SQL. , , , , T‑SQL. T‑SQL.
.
5.
, .
.
, : , T-SQL ( , , T-SQL ). , (, _-406_2). .
, ( ), .
1.
pass_transport
pass
pass
2.
remont
master
master
3.
school
pedcategoriya
pedcategoriya
4.
partiya
vznos
vznos
5.
soft
class
class
6.
cafe
povar
povar
7.
sclad
pogruzki
pogruzki
8.
sysadmins
users
users
9.
business
farm
farm
10.
raspisanie
week
week
:
1. , .
2. SQL.
3. ?
4. , intellisense. ?
5. .
6. ?
7. ?
8. ?
9. ?
10. , , ?
11. , ( )?
6
SQL. SELECT-
1) MSSQL. ( Temp). , (, Lab6_Tabakov_KT‑406).
|
|
2) (USE __). ( , education3).
, , ( , education3.txt).
3) .
:
- ,
- , ,
- MS SQL select .
4) . . . , , , .
!!!
5) . .
select:
SELECT [ALL | DISTINCT] <C >|*
FROM < >
[WHERE <- >]
:
1. ,
2. (),
3. ( ),
4. , , ( ),
5. (, , ), (),
6. , ,
7. (.. ), , ,
8. , ,
9. ,
10. ,
11. , ,
12. , ( ),
13. , ,
14. . , .
15. ,
16. , 2 (.) . , ,
17. , ( , ),
18. -, , ,
19. , 24 2003 . 13 2003 .,
20. , , ,
21. (), 80 , , , . , , ,
22. , ,
23. 5 , .
24. 5 , JOIN FOR.
1. SELECT.
2. SELECT WHERE?
3. ? ? ?
4. ?
5. ?
6. ?
7. , , .
8. DISTINCT?
9. WHERE .
10. ?
25.
7
TRANSACT-SQL (T-SQL).
T-SQL IF, CASE, BEGIN, END.
.
1. T-SQL ( ), .
2. , MS SQL (. 2).
3. MSSQL :
a. ( declare),
b. set,
c. T-SQL:
i. begin end,
ii. if else.
d. cast, convert ,
CAST:
CAST (expression AS data_type [ (length) ])
CONVERT:
CONVERT (data_type [ (length) ],expression [,style ])
e. CASE...END.
4. ( 6), , :
a. ( ) ,
b. ( ) ,
c. ( ) (case).
. ( ) .
d. ( ) (CAST() CONVERT()):
i. . ( ). : , , , .
ii. . ( ). , .
iii. ( ), . ( ) ( ). : , , , , .
b. , :
i. (, ) ( ) student (caseend).[2]
ii. , , ( ) , ( ).[3]
1. DECLARE.
2. SET.
3. CAST().
4. CONVERT().
5. CASE.