, table. . SELECT, , .
CREATE FUNCTION function_name
([ { @parameter_name [ AS ] parameter_data_type
[ = default ] }
[,...n ]
]
)
RETURNS TABLE
[ WITH [ ENCRYPTION ] [ SCHEMABINDING ] ]
[ AS ]
RETURN [ (] select_stmt [) ]
function _ name
.
@ parameter_name
. .
1 024 . , .
@. , . . , .
Parameter_data_type
. Transact-SQL timestamp, cursor table .
[ = default ]
. default, , .
, DEFAULT . DEFAULT , .
TABLE
, , , . , , .
, , TABLE SELECT. .
ENCRYPTION
, Database Engine CREATE FUNCTION . , , .
SCHEMABINDING
, , . SCHEMABINDING , , . , , .
|
|
, , :
.
ALTER, SCHEMABINDING.
Select_stmt
SELECT, , .
:
ufnGetEmployeeInfo. SELECT, .
CREATE FUNCTION ufnGetEmployeeInfo (@LoginName nvarchar(50))
RETURNS TABLE
AS
RETURN
(
SELECT u.FirstName, e.JobTitle
FROM Employee AS e INNER JOIN User AS u
ON e.UserID = u.UserID
WHERE u.LoginName = @LoginName;
);
SELECT *
FROM ufnGetEmployeeInfo ('admin');
. WHERE . , , , , , , . , , , . , , , .
18
, . - , . , , .
, , . ( ), . . , .
, , A B, B , .
|
|
ACID:
(Atomicity) , .
(Consistency) , .
(Isolation) .
(Durability) . , . , , .
:
. , , .
. , . , , .
. , , , . , , , .
. , , . , , .