Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
DETAILS
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version'CREATE TABLE DETAILS (ID INT PRIMARY KEY, NAME CHAR(20), COURSE CHAR(2), CITY CHAR(20)); INSERT INTO DETAILS VALUES(1,'MAHESH','SE','VIZAG'); INSERT INTO DETAILS VALUES(3,'KUMAR','EE','KURNOOL'); INSERT INTO DETAILS VALUES(4,'VAMSI','SE','VIJAYAWADA'); INSERT INTO DETAILS VALUES(7,'RAMESH','ME','VIZAG'); SELECT * FROM DETAILS WHERE ID<=3; CREATE TABLE WEATHER (ID INT PRIMARY KEY, TEMP INT CHECK (TEMP BETWEEN 20 AND 60), MONTH INT CHECK ( MONTH BETWEEN 1 AND 12)); INSERT INTO WEATHER VALUES(4,35,4); INSERT INTO WEATHER VALUES(13,45,7); SELECT * FROM WEATHER SELECT* FROM DETAILS,WEATHER WHERE DETAILS.ID=WEATHER.ID; UPDATE WEATHER SET MONTH=9 WHERE ID=13; SELECT *FROM WEATHER
run
|
edit
|
history
|
help
0
Marco - Arvind
Empleados
Consecutive publisher publish more than 2 books for 3 days
TEST
Demo
tt
テスト2
New
arithmetic
hi