* Id_ - - - |
* Id_ - - - - |
* Id_ - - - - - _ |
* - - - - - - |
* - - - - - - |
* * - |
N |
N |
N |
N |
N |
N |
N |
. 1.
:
1. , .
2. DDL.
DDL.
1.
ID | Int |
nChar | |
nChar | |
nChar | |
nChar | |
nChar |
( 1. )
create table (
id
char(50),
char(50),
char int primary key,
(50),
char(30),
char(30));
( )
2.
ID | int |
nchar | |
nchar | |
nchar |
( 2.
create table (
id int primary key,
char(30),
char(50),
char(30));
GO
( )
3.
int | |
int | |
int | |
int | |
int | |
int | |
int |
( 3. )
create table (
int primary key,
datetime,
int references (id),
int references (id),
int references (id),
decimal(10,2),
int check(>0));
( )
4.
int | |
Int | |
Int | |
Int | |
Int | |
Int | |
int |
( 4. )
create table (
int primary key,
datetime,
int references (id
int references (id),
|
|
int references (id),
decimal(10,2), int check(>0));
( )
5.
ID | int |
nchar | |
nchar | |
nchar | |
int |
( 5. )
create table (
id int primary key,
char(20),
char(50),
char(20),
decimal(10,2))
( )
2.2
, () . . , ; , .
1.
CREATE TRIGGER [dbo].[Not_null_date] ON [dbo].[]
AFTER INSERT NOT FOR REPLICATION AS
BEGIN
SET NOCOUNT ON;
DECLARE @new_Tovar_code int
DECLARE @new_Art nchar(20)
DECLARE @new_Edizm nchar(20)
DECLARE @new_Cena decimal(10,2)
SELECT @new_Tovar_code=[id],@new_Art=,@new_Edizm=[],@new_Cena=[] from inserted
IF EXISTS (SELECT *
FROM []
WHERE ='')
BEGIN
UPDATE [] SET =('!') WHERE [id] =@new_Tovar_code
END
IF EXISTS (SELECT *
FROM []
WHERE []='')
BEGIN
UPDATE [] SET []=('!') WHERE [id] =@new_Tovar_code
END
IF EXISTS (SELECT *
FROM []
WHERE ='')
BEGIN
UPDATE [] SET =('!') WHERE [id] =@new_Tovar_code
END
END
(. 7, )
2.
Create TRIGGER [dbo].[Check_Double_MOL] ON [dbo].[]
FOR INSERT
AS
IF EXISTS (SELECT *
FROM [], inserted
WHERE [].[id]=inserted.[id] and [].[]=inserted.[] and [].[]=inserted.[]
and [].[]=inserted.[])
BEGIN
raiserror (' , !',16,1)
ROLLBACK tran
END
(. 8, )
3.
Create TRIGGER [dbo].[Check_Double_Post] ON [dbo].[]
FOR INSERT
AS
IF EXISTS (SELECT *
FROM [], inserted
WHERE [].[]=inserted.[] and [].[]=inserted.[] and [].[]=inserted.[]
and [].[]=inserted.[] and [].[]=inserted.[] and [].[]=inserted.[] and [].[]=inserted.[])
BEGIN
raiserror (' , !',16,1)
ROLLBACK tran
END
(. 9, )
4.
CREATE TRIGGER [dbo].[Check_Double_prodaj] ON [dbo].[]
FOR INSERT
AS
IF EXISTS (SELECT *
|
|
FROM [], inserted
WHERE [].[]=inserted.[] and [].[]=inserted.[] and [].[]=inserted.[]
and [].[]=inserted.[] and [].[]=inserted.[] and [].[]=inserted.[] and [].[]=inserted.[])
BEGIN
raiserror (' , !',16,1)
ROLLBACK tran
END
GO
(. 10, )
5.
CREATE TRIGGER [dbo].[Check_Double_Key] ON [dbo].[]
FOR INSERT
AS
IF EXISTS (SELECT *
FROM [], inserted
WHERE [].=inserted. and [].[]=inserted.[] and [].[]=inserted.[]
and [].[]=inserted.[])
BEGIN
raiserror (' , !',16,1)
ROLLBACK tran
END
(. 11, )
2.3
, , - , , . .
1.
use Kurs_1
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[sp_sum_ostatk]
@SkladNumber int,
@TovarNumber int,
@Sklad_name char(30) output,
@Tovar_name char(50) output
AS
BEGIN
SET NOCOUNT ON;
SELECT @Sklad_name=()
FROM dbo.
WHERE id=@SkladNumber
SELECT @Tovar_name=()
FROM dbo.
WHERE id=@TovarNumber
END
(. 12, )
2.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[sp_sum_postoav]
@SkladNumber int,
@TovarNumber int,
@KontrNumber int,
@Sklad_name char(30) output,
@Tovar_name char(50) output,
@Kontr_name char(50) output
AS
BEGIN
SET NOCOUNT ON;
SELECT @Sklad_name=()
FROM dbo.
WHERE id=@SkladNumber
SELECT @Tovar_name=()
FROM dbo.
WHERE id=@TovarNumber
SELECT @Kontr_name=()
FROM dbo.
WHERE id=@KontrNumber
END
(. 13, )
3.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_sum_prodaj]
@SkladNumber int,
@TovarNumber int,
@KontrNumber int,
@Sklad_name char(30) output,
@Tovar_name char(50) output,
@Kontr_name char(50) output
AS
BEGIN
SET NOCOUNT ON;
SELECT @Sklad_name=()
FROM dbo.
WHERE id=@SkladNumber
SELECT @Tovar_name=()
FROM dbo.
WHERE id=@TovarNumber
SELECT @Kontr_name=()
FROM dbo.
WHERE id=@KontrNumber
END
(. 14, )
4.
CREATE PROCEDURE [dbo].[Otch_sklad]
AS
BEGIN
SET NOCOUNT ON;
SELECT .[id] as ID, ,,
FROM
GROUP BY .[id], ,,
END
GO
(. 15, )
5.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Otch_Tovar]
AS
BEGIN
SET NOCOUNT ON;
SELECT .[id] as id, ,,,
|
|
FROM
GROUP BY .[id], id,,,,
END
GO
(. 16, )
6.
Create PROCEDURE [dbo].[Otch_Kontr]
AS
BEGIN
SET NOCOUNT ON;
SELECT .[id] as id, ,,,,
FROM
GROUP BY .[id], ,,,,
END
(. 17, )
, Visual Studio C# Sql Server. .
:
, , , .
䔻.
. , SQL Server. , SQL Server Visual Studio.
, , .
, . , . .
, . , . . . .