SHOW:
|
|
- or go back to the newest paste.
| 1 | CREATE TABLE [dbo].[Persona]( | |
| 2 | [Personas_Kods] [nchar](11) NOT NULL, | |
| 3 | [Vards] [nvarchar](30) NOT NULL, | |
| 4 | [Uzvards] [nvarchar](30) NOT NULL, | |
| 5 | [Adrese] [nvarchar](40) NULL, | |
| 6 | CONSTRAINT [PK_Personas_Kods] PRIMARY KEY CLUSTERED ([Personas_Kods]) | |
| 7 | ) | |
| 8 | GO | |
| 9 | ||
| 10 | CREATE TABLE [dbo].[Darba_vieta]( | |
| 11 | [Registracijas_Nummurs] [nvarchar](20) NOT NULL, | |
| 12 | [Nosaukums] [nvarchar](50) NULL, | |
| 13 | [Dibinasanas_datums] [date], | |
| 14 | [Adrese] [nvarchar] (70) NULL, | |
| 15 | CONSTRAINT [PK_Registracijas_Nummurs] PRIMARY KEY CLUSTERED ([Registracijas_Nummurs]), | |
| 16 | ) | |
| 17 | GO | |
| 18 | ||
| 19 | CREATE TABLE [dbo].[Darbu_info]( | |
| 20 | [Personas_Kods] [nchar](11) NOT NULL, | |
| 21 | [Registracijas_Nummurs] [nvarchar](20) NOT NULL, | |
| 22 | [Amats] [nvarchar](30) NOT NULL, | |
| 23 | [Alga] [decimal] (10,2) NOT NULL, | |
| 24 | [Darba_sakums] [date], | |
| 25 | [Darba_beigas] [date] NULL, | |
| 26 | CONSTRAINT [FK_Personas_Kods] FOREIGN KEY ([Personas_Kods]) | |
| 27 | REFERENCES Persona([Personas_Kods]), | |
| 28 | CONSTRAINT [FK_Registracijas_Nummurs] FOREIGN KEY (Registracijas_Nummurs) | |
| 29 | REFERENCES Darba_vieta(Registracijas_Nummurs), | |
| 30 | ) | |
| 31 | GO | |
| 32 | - | SELECT Registracijas_Nummurs, Nosaukums FROM Darba_vieta WHERE date BETWEEN '01-01-2011' AND '31-12-2011' |
| 32 | + | SELECT Registracijas_Nummurs, Nosaukums FROM Darba_vieta WHERE Dibinasanas_datums BETWEEN '01-01-2011' AND '31-12-2011' |
