.


:

:



,



( , )

:

































 

 

 

 
FAQ

⇐ 1234 ⇒



, . (), ( ), , , , , . .

, , , .

() , ( ), , , , , . : , , , . : .

.


 

1.4

- , . - , , . . . SQL .

: OpenEdge, SQLite, BerkeleyDB, Firebird Embedded, Microsoft SQL Server Compact, .

.. MS SQL Server 2014 ( ..) .. , MS Visual Studio 2015 ( , ..)

1.


 

 

MS SQL Server :

1. , , .

2. DDL . . : CREATE TABLE < > (< > < > PRINORY KEY ( ))

: , , , , , .


 

1.

NULL
ID int
nchar
nchar

( 1. )

 

USE [Administraciya] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[]( [ID ] [int] NOT NULL, [] [nchar](20) NULL, [ ] [nchar](200) NULL, CONSTRAINT [PK_] PRIMARY KEY CLUSTERED ( [ID ] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO

( )

 

 


 

2.

NULL
Int
ID Int
ID Int
ID Int
ID Int
Date
Nchar(100)

( 2. )

USE [Administraciya]

GO

 

/****** Object: Table [dbo].[] Script Date: 04.07.2016 1:32:41 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[](

[ ] [int] NOT NULL,

[ID ] [int] NOT NULL,

[ID ] [int] NOT NULL,

[ID ] [int] NOT NULL,

[ID ] [int] NOT NULL,

[] [date] NULL,

[] [nchar](100) NULL,

CONSTRAINT [PK_] PRIMARY KEY CLUSTERED

(

[ ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__]

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__]

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__1] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__1]

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__]

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__]

GO

( )

 

 

3.

NULL
ID int
nChar
nChar
nChar
nChar
Date
nChar
nChar
nChar
ID Int
ID Int

( 3. )

USE [Administraciya]

GO

 

/****** Object: Table [dbo].[] Script Date: 04.07.2016 1:51:18 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[](

[ID ] [int] NOT NULL,

[] [nchar](100) NULL,

[] [nchar](10) NULL,

[] [nchar](15) NULL,

[ ] [nchar](300) NULL,

[ ] [date] NULL,

[] [nchar](200) NULL,

[] [nchar](50) NULL,

[] [nchar](10) NULL,

[ID ] [int] NULL,

[ID ] [int] NULL,

CONSTRAINT [PK_] PRIMARY KEY CLUSTERED

(

[ID ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__]

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__]

GO

( )

 

4.

NULL
ID Int
nChar
nChar
nChar
nChar
nChar
nChar
nChar

( 4. )

USE [Administraciya]

GO

 

/****** Object: Table [dbo].[] Script Date: 04.07.2016 1:59:56 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[](

[ID ] [int] NOT NULL,

[] [nchar](10) NULL,

[ ] [nchar](100) NULL,

[] [nchar](10) NULL,

[] [nchar](10) NULL,

[ ] [nchar](300) NULL,

[ ] [nchar](100) NULL,

[ ] [nchar](100) NULL,

CONSTRAINT [PK_] PRIMARY KEY CLUSTERED

(

[ID ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

 

GO

( )

 

5.

NULL
ID int
nChar
nChar
nChar (10)
ID Int
nChar
nChar

( 5. )

 

USE [Administraciya]

GO

 

/****** Object: Table [dbo].[] Script Date: 04.07.2016 2:00:53 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[](

[ID ] [int] NOT NULL,

[] [nchar](100) NULL,

[] [nchar](100) NULL,

[] [nchar](100) NULL,

[ID ] [int] NOT NULL,

[] [nchar](100) NULL,

[] [nchar](20) NULL,

CONSTRAINT [PK_] PRIMARY KEY CLUSTERED

(

[ID ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__]

GO

( )

 

 

6.

NULL
ID Int
nChar
ID Int
nChar

( 6. )

USE [Administraciya]

GO

 

/****** Object: Table [dbo].[] Script Date: 04.07.2016 2:07:26 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

CREATE TABLE [dbo].[](

[ID ] [int] NOT NULL,

[] [nchar](100) NULL,

[ID ] [int] NOT NULL,

[] [nchar](100) NULL,

CONSTRAINT [PK_] PRIMARY KEY CLUSTERED

(

[ID ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

 

GO

 

ALTER TABLE [dbo].[] WITH CHECK ADD CONSTRAINT [FK__] FOREIGN KEY([ID ])

REFERENCES [dbo].[] ([ID ])

GO

 

ALTER TABLE [dbo].[] CHECK CONSTRAINT [FK__]

GO

( )

 

 

 


 

 

:

1. , .

2. DDL.

DDL.

1. .

 

2.

insert into (ID , , )
values (1, , , )

insert into (ID , , )
values (2,, , )

insert into (ID , , )
values (3, , , )

( )

 

 

2. .

 

3.

insert into (ID , , ID , )
values (1,, 1, )

insert into (ID , , ID , )
values (2,-, 2, )

insert into (ID , , ID , )
values (3, , 3, )

( )

3. .

 

 

4.

insert into ( , ID , ID , ID , ID , , )
values (1,1,1,1,1,2015-07-27, )

insert into ( , ID , ID , ID , ID , , )
values (2,3,2,2,3,2016-06-27, )

insert into ( , ID , ID , ID , ID , , )
values (3,3,2,2,3)

( )

4. .

 

5.

insert into (ID , , ,, , , , , ,ID , ID )
values (1, , 8111,123456, -, 1950-01-01, , -, 15, ,1,1)

insert into (ID , , ,, , , , , ,ID , ID )
values (2, , 8234,789191, -, 1985-06-03, , , ,2,2)

insert into (ID , , ,, , , , , ,ID , ID )
values (3, , 8148,512342, -, 1973-09-02, , -, . 3, ,3,3)

( )

5. .

 

6.

 

insert into (ID ,, , , , , , )
values (1,,,8112,123123, , 1 , )

insert into (ID ,, , , , , , )
values (2,,,8423,423134, , 2 , )

insert into (ID ,, , , , , , )
values (3, , ,8110, 312312, , 1 , )

( )

6. .

 

7.

insert into (ID , , , , ID , , )
values (1,,,,1,-,.,3,88005553535)

insert into (ID , , , , ID , , )
values (2,, , ,1,-,. 7,61-23-45)

insert into (ID , , , , ID , , )
values (3, ,,,2,-,- 50 2,23-45-21)

insert into (ID , , , , ID , , )
values (4, ,,,3,-, 15,666-666)

( )

 

SQL :

, ;

() ;

() ;

() ;

() .

 

:

1. , (.7)

SELECT [ID ],.,.,.

FROM [dbo].[],dbo.,dbo.

where .[ID ]=.[ID ] and .[ID ]=.[ID ]

GO

 

( Select1)

 

8. Select1

 

2. ,

SELECT .[ID ] as ID, ,,, ., ., ,, .

FROM

LEFT JOIN ON

.[ID ]=.[ID ]

LEFT JOIN ON

.[ID ]=.[ID ]

GROUP BY .[ID ], ,,, ., ., ,, .

( Select2)

9. Select2

 

3. ,

SELECT .[ID ] as ID,,.,.,.,/*.[ ] as , .[ ] as */.

FROM

/*LEFT JOIN ON

.[ID ]=.[ID ]*/

LEFT JOIN ON

.[ID ]=.[ID ]

GROUP BY .[ID ],,.,.,.,/*.[ ], .[ ]*/.

( Select3)

10. Select3

 

4. , , ,

SELECT .[ ] as ,.,.,.,.[ ] as ,.,.,.,.,.

FROM []

LEFT JOIN ON

.[ID ]=.[ID ]

LEFT JOIN ON

.[ID ]=.[ID ]

LEFT JOIN ON

.[ID ]=.[ID ]

LEFT JOIN ON

.[ID ]=.[ID ]

GROUP BY .[ ],.,.,.,.[ ],.,.,.,.,.

( Select4)

11. Select4

5. ,

SELECT [ ],

.,.,.

,[ID ]

,[ID ]

,[ID ]

,[]

,[]

FROM [dbo].[],dbo.

where

.[ID ]=.[ID ]

( Select5)

12. Select5

 

6. ,

SELECT [ ],

.,.,.

,[ID ]

,[ID ]

,[ID ]

,[]

,[]

FROM [dbo].[],dbo.

where

.[ID ]=.[ID ]

( Select6)

 

13. Select6

7. , , ID .

SELECT @Sotrud_Name=()

FROM

WHERE [ID ]=@IDSotrud

 

SELECT @Ochered_Name=()

FROM

WHERE [ID ]=@IDOchered

 

SELECT @Chelen_name=([ ])

FROM

WHERE [ID ]=@IDOchelen

 

SELECT @Group_name=()

FROM

WHERE [ID ]=@IDGroup

( Select7)

8. , , ID .

SELECT @Dolg_Name=()

FROM

WHERE[ID ]=@IDDolg

( Select8)

9. , , ID ID .

SELECT @Chelen_name=([ ])

FROM

WHERE [ID ]=@IDChelen

 

SELECT @Group_name=()

FROM

WHERE [ID ]=@IDGroup

( Select9)

10. , , ID ID .

SELECT @Group_Name=()

FROM

WHERE [ID ]=@IDGroup

( Select10)

 


 

 

⇐ 1234 ⇒


:

: 2017-01-28; !; : 301 |

:

:

, .
==> ...

1715 - | 1497 -


© 2015-2024 lektsii.org - -

: 0.197 .