MySQL
. MySQL , , .
MySQL
- MySQL ;
- MySQL SQL;
- ;
- MySQL ;
MySQL
, ;
;
;
SQL
SQL - .
SQL
SQL , .
SQL
. ( ), ( ), , ( ).
, , , , .
() , , , , . : , . : .
, ,
* Id_ - - - |
* Id_ - - - - |
* Id_ - - - - - _ |
* - - - - - - |
* - - - - - - |
* * - |
N |
N |
N |
N |
N |
N |
N |
:
:
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))
( )
:
, () . . , ; , .
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, Not_null_date)
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, Check_Double_MOL)
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, Check_Double_Post)
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, Not_null_date_Prodaj)
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, Check_Double_Key)
:
, , - , , . .
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, sp_sum_ostatk)
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, sp_sum_postoav)
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, sp_sum_prodaj)
CREATE PROCEDURE [dbo].[Otch_sklad]
AS
BEGIN
SET NOCOUNT ON;
SELECT .[id] as ID, ,,
FROM
GROUP BY .[id], ,,
END
GO
(. 15, )
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, )
Create PROCEDURE [dbo].[Otch_Kontr]
AS
BEGIN
SET NOCOUNT ON;
SELECT .[id] as id, ,,,,
FROM
GROUP BY .[id], ,,,,
END
(. 17, Otch_Kontr)
, Visual Studio C# Sql Server. .
:
, , , .
䔻.
. , SQL Server. , SQL Server Visual Studio.
, , .
, . , . .
, . , . . . .
|
|