6. SQL Server.
, .
Transact-SQL EXECUTE. , , .
Transact-SQL, , SQL Server .
.
.
, .
.
, SQL.
.
. .
, .
, .
.
, Transact-SQL, , , .
:
1. : Transact-SQL
2.
3.
Transact-SQL.
:
:
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
--
<@Param1, sysname, @p1> <Datatype_For_Param1,, int> = <Default_Value_For_Param1,, 0>,
<@Param2, sysname, @p2> <Datatype_For_Param2,, int> = <Default_Value_For_Param2,, 0>
AS
BEGIN
-- Transact-SQL
SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
CREATE ALTER. , .
,
, :
CREATE PROCEDURE [dbo].[spOrderInfo]
@OrderID INT
|
|
AS
--
SELECT * FROM [OrderDet]
WHERE OrderID = @OrderID
, EXEC EXECUTE. . , - .
EXECUTE spOrderInfo 5
, . . , :
CREATE PROCEDURE spOrdersByPeriod
@DataN DATETIME,
@DataK DATETIME = NULL
AS
BEGIN
IF (@DataK IS NULL)
SET @DataK = GETDATE()
SELECT * FROM [Order] WHERE OrderDate BETWEEN @DataN AND @DataK
END
:
EXECUTE spOrdersByPeriod '01.03.2011', '01.04.2011'
:
EXECUTE spOrdersByPeriod '01.03.2011'
:
1. , Grup. : . (null) 0, , , . , .
2. , .