(DATE, TIME, DATETIMEOFFSET, DATETIME2, Hierarchyid, GEOMETRY, GEOGRAPHY, FILESTREAM)
a) DATE
b) TIME
c) DATETIMEOFFSET + -
d) DATETIME2 January 1, 0001 December 31, 9999
e) HierarchyId .
21. / ( MSSQLServer2008 MSSQLServer2005).
.
CREATE NONCLUSTERED INDEX IX_TestTable_OneON TestTable(TestTableVarFieldOne)
WHERE TestTableVarFieldOne = 'SampleText'
:
- = SampleText, , .
)
?
1) - INSERT/UPDATE ,
2)
:
1)
2)
3) ( )
4)
:
, ,
GO
CREATE TYPE Customer AS TABLE (id int, CustomerName nvarchar(50), postcode nvarchar(50));
GO
CREATE TABLE Customers (id int, CustomerName nvarchar(50));
GO
CREATE TABLE CustomerPostCodes(id int, postcode nvarchar(50));
GO
CREATE Procedure AddCustomers (@customer Customer READONLY)
AS
INSERT INTO Customers
SELECT id, CustomerName FROM @customer
INSERT INTO CustomerPostCodes
SELECT id, postcode FROM @customer
GO
MSSQLServer2005. , , .
MSSQLServer2005. . , . .
. . CAST CONVERT. . COALESCE, CASE, ISNULL. .
. , . .
. , . .
. , . .
Commontableexpressions (cte). . cte. cte . .
. From, , . ..
. , ( FROM). .
() . , . .
|
|
. , . .
. . (). . . .
13. . . / DML (). (). , ( COLUMNSUPDATED UPDATE). inserted deleted. .
. . DML . , . , DML.
15. . . / DDL (). (). , ( EVENTDATA). .
16. . . / LOGON (). (). .
17. . . / ( ENABLE/ DISABLE ALTERTABLE, / ). . . .
18. . . / , ( ). . . .
19. . . / ( ). , . . (). .