Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
robot-grading
--Sql Server 2014 Express Edition --Batches are separated by 'go' --select @@version as 'sql server version' --CREATE TABLE team (TeamNumber int not null, TypeOfDrive text not null); --insert into team (TeamNumber, TypeOfDrive) values -- (1699, 'pneumatics'), (225, 'tank'), (312, 'tank'); --SELECT * from TypeOfDrive; --code that checked that null does work with txt data structure. --CREATE TABLE team (TeamNumber text not null); --insert into team (TeamNumber) values -- ('1699 -tank'), ('225 -pneumatics'), ('312 -tank'); --SELECT TeamNumber from team; CREATE TABLE verify (teamNum int not null, driveType text not null, can_climb char(5) not null, High_Goal char(5) not null, Low_Goal char(5) not null); insert into verify (teamNum, driveType, can_climb, High_Goal, Low_Goal) values (1699,'tank', 'True', 'True', 'False'), (255, 'pneumatics', 'False', 'False', 'True'); SELECT * from verify;
run
|
edit
|
history
|
help
0
Pro 2
Hacker - submissions Interview Questions
SQL Server - NULL values with IN and NOT IN
mi
ms sql - update/insert - date concatenation
StackOverflow_53753663
sql
2021.02.24 Lab 4
test
SQL - Find series of timestamps with small gaps