enrolled in a yearly course has incorrect --data in records with ids between 20 and 100 (inclusive)
---------------------------------------------------------
--A table containing the students enrolled in a yearly course has incorrect
--data in records with ids between 20 and 100 (inclusive).
DROP TABLE IF EXISTS enrollments;
CREATE TABLE enrollments
(id int NOT NULL PRIMARY KEY,
year int NOT NULL,
studentId int NOT NULL)
-- insert sample data
Declare @Id int
Set @Id = 1
Declare @studentId int
Set @studentId = 10
Declare @LowerLimitForYear int
Declare @UprerLimitForYear int
Set @LowerLimitForYear= 2000
Set @UprerLimitForYear= 2100
Declare @RandomYear int
while(@Id <= 200)
Begin
select @RandomYear = ROUND((@UprerLimitForYear -@LowerLimitForYear)* RAND() +1,0)*100
Insert into enrollments
Values(@Id,@RandomYear,@studentId)
Set @Id = @Id +1
Set @studentId = @studentId +10
END
--Write a query that updates the field 'year'
-- of every faulty record to 2015.
update enrollments
set [year] = 2015
where id between 20 and 100
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line