queries.sql

Student Table and Department Table

queries.sql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
CREATE SCHEMA [dtl]
GO
CREATE SCHEMA [Query]
GO
CREATE TABLE [dtl].[Departments]
(
  DepartmentId INT IDENTITY(1,1),
  DepartmentName NVARCHAR(100) NOT NULL,
  CONSTRAINT PK_Departments PRIMARY KEY (DepartmentID),
  CONSTRAINT FK_Department FOREIGN KEY(DepartmentId) REFERENCES  [dtl].[Departments](DepartmentId)
 
)
GO
CREATE TABLE [Query].[Students]
(
  StudentId INT IDENTITY(1,1),
    FirstName NVARCHAR(50) NOT NULL,
    LastName NVARCHAR(50) NOT NULL,
    Age INT NOT NULL,
    DOB DATE Not NULL,
    Email NVARCHAR(255) NOT NULL ,
    Mobile NVARCHAR(50) NOT NULL,
    DepartmentId INT NOT NULL,
    CONSTRAINT PK_Students PRIMARY KEY (StudentId)
)
GO
INSERT INTO [Query].[Students] Values ('Karthi', 'Saravanan', 24, '2001-04-27', 'skarthick17@gmail.com', '7837987369', 2),
                            ('MOUNIKHA', 'K', 22, '2002-02-05', 'mounich2002@gmail.com', '9920044220', 3),
                            ('MADHU', 'M', 24, '2000-04-30', 'style2000@gmail.com', '7993921990', 3),
                            ('DINESH', 'KAUMAR', 24, '2000-04-26', 'dkumar2017@gamil.com', '8817711003', 4),
                            ('Karthi', 'S', 23, '2001-06-29', 'karthi435@gmail.com', '8837492929', 4),
                            ('MOUNI', 'C', 24, '2000-08-12', 'mouni568@gmail.com', '6829949920', 5),
                            ('DEVI', 'S', 26, '1999-04-30', 'devi9951@gmail.com', '7932402948', 1),
                            ('RAVI', 'SHANKAR', 25, '1998-04-26', 'msdrdk2011@gamil.com', '6328849202', 1),
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

STDIN

Output:

Msg 10709, Level 16, State 1, Server 4604a73dfe25, Line 4
The number of columns for each row in a table value constructor must be the same.

(7 rows affected)
StudentId   FirstName                                          LastName                                           Age         DOB              Email                                                                                                                                                                                                                                                           Mobile                                             DepartmentId
----------- -------------------------------------------------- -------------------------------------------------- ----------- ---------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- ------------

(0 rows affected)
DepartmentId DepartmentName                                                                                      
------------ ----------------------------------------------------------------------------------------------------
           1 IT                                                                                                  
           2 CSE                                                                                                 
           3 ECE                                                                                                 
           4 EEE                                                                                                 
           5 MECH                                                                                                
           6 BIO-MEDICAL                                                                                         
           7 AGRICUTURE                                                                                          

(7 rows affected)

created 2 years ago

Student Table and Department Table

OneCompiler.com

Languages

More