(1000, N ' ..','19550219','[email protected]',2,1,NULL),
(1001, N ' ..','19831203','[email protected]',3,3,1003),
(1002, N ' ..','19760607','[email protected]',1,2,1000),
(1003, N ' ..','19820417','[email protected]',4,3,1000)
, INCLUDE. .. INCLUDE- - , , . , (SELECT), , . , .. .
MSDN.
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
ON < object > (column [ ASC | DESC ] [,... n ])
[ INCLUDE (column_name [,... n ]) ]
(SELECT), , .. .
, , , . , , .
DDL
, DDL , . , .
, .
SQL (DDL, DML) MS SQL Server. tutorial
SQL*, Microsoft SQL Server*
DDL Data Definition Language ( )
habrahabr.ru/post/255361
DML Data Manipulation Language ( )
DML, , MERGE.
DML . , , , , SQL.
.. ( ), , , .. . , .
, , SQL . , , - , , . , .
|
|
.. DML MS SQL SELECT, DML . SELECT DML, .. .
DML :
SELECT
INSERT
UPDATE
DELETE
MERGE
, , SELECT, :
SELECT [ DISTINCT ] _ *
FROM
WHERE
ORDER BY _
SELECT , . , , , , .. (, ..).
, TOP. , .. - SQL.
DDL , .. (, ..), DML , .
Step by Step, .. . . - , , - , .
Test, DDL+DML .
, (.. DDL), :
Test
, DML.
SELECT
, , Test, USE Test.
SELECT:
SELECT *
FROM Employees
( *) Employees _ _. , , , ID ( , .. ORDER BY ):
ID | Name | Birthday | PositionID | DepartmentID | HireDate | ManagerID | |
.. | 1955-02-19 | [email protected] | 2015-04-08 | NULL | |||
.. | 1983-12-03 | [email protected] | 2015-04-08 | ||||
.. | 1976-06-07 | [email protected] | 2015-04-08 | ||||
.. | 1982-04-17 | [email protected] | 2015-04-08 |
, MS SQL SELECT FROM, , - :
|
|
SELECT
5550/100*15,
SYSDATETIME(), --
SIN (0)+ COS (0)
(No column name) | (No column name) | (No column name) |
2015-04-11 12:12:36.0406743 |
, (5550/100*15) 825, (832.5). 825 , , , .. (5550/100) 55, (55.5).
, MS SQL :
/ = (.. )
/ =
/ =
.. , 2- ( , ):
SELECT
123/10, -- 12
123./10, -- 12.3
123/10. -- 12.3
(123.) = (123.0), 0 .
, .
. , , , (123.).
CAST CONVERT. ID, int:
SELECT
ID,
ID /100, --
CAST (ID AS float)/100, -- CAST float
CONVERT (float, ID)/100, -- CONVERT float
ID /100. --
FROM Employees
ID | (No column name) | (No column name) | (No column name) | (No column name) |
10.000000 | ||||
10.01 | 10.01 | 10.010000 | ||
10.02 | 10.02 | 10.020000 | ||
10.03 | 10.03 | 10.030000 |
. ORACLE FROM , DUAL, :
SELECT
5550/100*15, -- ORACLE 832.5
sysdate,
sin (0)+ cos (0)
FROM DUAL
. :
SELECT *
FROM dbo.Employees -- dbo
, , ..
, - , .. , . MS SQL , (. CREATE SCHEMA).
MS SQL dbo (Database Owner) . , , dbo . , , , CREATE TABLE _._().
MS SQL , :
SELECT *
FROM Test. dbo.Employees -- _._.
|
|
, , :
,
..
, , .
, -- , /* */ . , , - , , .
, , , , :
SELECT ID,Name
FROM Employees
.. , ID Name. ( , Name):
ID | Name |
.. | |
.. | |
.. | |
.. |
. , , . Display Estimated Execution Plan Include Actual Execution Plan ( , , ):
, .
DML, , ( ) DML , . , , , . , . .
, FROM: