Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
FIGURA5.4
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' CREATE TABLE [dbo].[PERSON]( [P_ID] [nvarchar](255) Primary Key NOT NULL, --PK [P_LNAME] [nvarchar](255) NULL, [P_FNAME] [nvarchar](255) NULL, [P_IS_EMP] [nvarchar](255) NULL, [P_IS_STU] [nvarchar](255) NULL ) CREATE TABLE [dbo].[EMPLOYEE]( [P_ID] [nvarchar](255) Primary Key NOT NULL, --PK [EMP_HERE_DATE][nvarchar](255) NULL, [EMP_IS_ADM][nvarchar](255) NULL, [EMP_IS_PROF][nvarchar](255) NULL ) CREATE TABLE [dbo].[STUDENT]( [P_ID] [nvarchar](255) Primary Key NOT NULL, --PK [STU_MAJOR][nvarchar](255) NULL, [STU_TYPE][nvarchar](255) NULL ) CREATE TABLE [dbo].[ADMINISTRATOR]( [P_ID] [nvarchar](255) Primary Key NOT NULL, --PK [ADM_TITLE][nvarchar](255) NULL ) CREATE TABLE [dbo].[PROFESSOR]( [P_ID] [nvarchar](255) Primary Key NOT NULL, --PK [PROF_RANK][nvarchar](255) NULL ) CREATE TABLE [dbo].[GRADUATE]( [P_ID] [nvarchar](255) Primary Key NOT NULL, --PK [GRAD_THESIS][nvarchar](255) NULL ) CREATE TABLE [dbo].[UNDERGRAND]( [P_ID] [nvarchar](255) Primary Key NOT NULL, --PK [UND_HOURS][nvarchar](255) NULL ) GO INSERT INTO [dbo].[PERSON] VALUES ('4593', 'Luna', 'Carlos', ' ', ' '), ('5698', 'Vargas', 'Arturo', ' ', ' '), ('7893', 'León', 'Jorge', ' ', ' ') INSERT INTO [dbo].[EMPLOYEE] VALUES('4593','2020-04-21 13:05', ' ', ' '), ('5697','2020-07-07 16:02', ' ', ' '), ('7893','2020-08-01 17:55', ' ', ' ') INSERT INTO [dbo].[STUDENT] VALUES ('4593', ' ', ' '), ('5697', ' ', ' '), ('7893', ' ', ' ') INSERT INTO [dbo].[ADMINISTRATOR] VALUES('4593', ' '), ('5697', ' '), ('7893', ' ') INSERT INTO [dbo].[PROFESSOR] VALUES('4593', ' '), ('5697', ' '), ('7893', ' ') INSERT INTO [dbo].[GRADUATE] VALUES('4593', ' '), ('5697', ' '), ('7893', ' ') INSERT INTO [dbo].[UNDERGRAND] VALUES('4593', ' '), ('5697', ' '), ('7893', ' ') select * from PERSON select * from EMPLOYEE select * from STUDENT select * from ADMINISTRATOR select * from PROFESSOR select * from GRADUATE select * from UNDERGRAND
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
HOTEL
BC160401693
Libros
newtable
mywall
get first parent with a value
Combined Where and having
TEST 2
New
Sql server 2012 features list
Please log in to post a comment.