, .
.
.5
, .
. 6
:
. 7
. .
, , , .
:
. 8 1010.
.
.9 - 4043 ..
.
.10 .
, , , .
11. .
- .
.12. .
. .
. .
.
.
.
.13 .
, . .
.14 .
.
.15 4043.
, .
.16 .
. . , . , , .
|
|
Microsoft Access SQL Server Management Studio Express. .
|<, <, >, >|, (- : , , ).
, , , , .
, : , , .
( , , ), . , , .
.
1. .., .. . . 2006.
2. .. , .. MICROSOFT ACCESS 2007 .
3. .. 2005.
1.
.
1. .
USE []
GO
/****** Object: Trigger [dbo].[stoimost] Script Date: 12/22/2010 19:31:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[stoimost]
ON [dbo].[]
FOR INSERT
AS
DECLARE @X1 int
DECLARE @X2 int
DECLARE @X3 int
DECLARE @X4 int
DECLARE @X5 int
DECLARE @X6 float
DECLARE @X7 smallmoney
DECLARE @X8 datetime
DECLARE @X9 int
DECLARE @X10 float
DECLARE @X11 smallmoney
DECLARE @X12 float
SELECT @X1=I._ FROM INSERTED I
SELECT @X2=I._ FROM INSERTED I
SELECT @X3=I._ FROM INSERTED I
SELECT @X4=_ FROM INSERTED I
SELECT @X5=_ FROM INSERTED I
SELECT @X6=I. FROM INSERTED I
SELECT @X8=I. FROM INSERTED I
SELECT @X9=_ FROM _
SELECT @X10=_ FROM _ WHERE _=@X2
SELECT @X11=_1_ FROM WHERE _=@X4 and _=@X5
SELECT @X12=_ FROM _ WHERE _=@X9
SET @X7=@X6*@X10*@X11*@X12
UPDATE ê
SET =@X6*@X10*@X11*@X12
WHERE _=@X1
UPDATE SET _= _ -@X7 WHERE _=@X3
2. .
USE []
GO
/****** Object: Trigger [dbo].[SostSch] Script Date: 12/22/2010 19:51:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[SostSch]
ON [dbo].[]
FOR INSERT
AS
BEGIN
DECLARE @X1 SMALLMONEY
DECLARE @X2 SMALLMONEY
DECLARE @X3 SMALLMONEY
DECLARE @X4 INT
|
|
DECLARE @X5 INT
SELECT @X1=I. FROM INSERTED I
SELECT @X2= FROM
SELECT @X4=_ FROM
SELECT @X5=_ FROM
IF(@X4=@X5)
BEGIN
SET @X3=@X1-@X2
END
ELSE
BEGIN SET @X3=@X1
END
UPDATE
SET _=@X3
WHERE =@X1
END
3. , :
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Otchet1]
(@date1 datetime, @date2 datetime)
AS
BEGIN
SET NOCOUNT ON;
SELECT , , _, _, , , _,
FROM ,
WHERE ( BETWEEN @date1 AND @date2) AND
(._=._)
END
4. , .
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Spisok]
AS
BEGIN
SET NOCOUNT ON;
SELECT , _, , , _, _, , _
FROM ORDER BY
END
5. , :
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Poisk](@_ int,@ char(20))
AS
BEGIN
SET NOCOUNT ON;
SELECT _, , , , _ FROM
WHERE _=@_ AND =@
END
6. , .
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Raschet](@nom int, @avans int)
AS
BEGIN
SET NOCOUNT ON;
UPDATE SET _ = _ + @avans WHERE _=@nom
SELECT _, _, , FROM WHERE _ =@nom
END