.


:




:

































 

 

 

 


,

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. , .



<== | ==>
20. | . 1
:


: 2016-09-03; !; : 341 |


:

:

, ,
==> ...

772 - | 778 -


© 2015-2024 lektsii.org - -

: 0.013 .