Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL basics(Data Definition Language)
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table friends (ID INTEGER, NAME TEXT, Birthday TEXT); insert into friends values(1,'Jane Doe','May 19th 1993') insert into friends values(2,'Sabir Patel','December 11th 1995') insert into friends values(3,'Imran Mansuri','October 21 1995') insert into friends values(4,'Rizwan Shaikh','July 22 1995'); /*Look up table friends*/ select * from friends; /*updating table friends*/ update friends set name = 'Jane Smith' where id = 1; select * from friends; /*adding column*/ alter table friends ADD Email TEXT; select * from friends; /*updating table friends*/ update friends set email = 'jdoe@example.com' where id =1; /*updating table friends*/ update friends set email = 'sabir@example.com' where id = 2; /*updating table friends*/ update friends set email = 'imran@example.com' where id = 3; /*updating table friends*/ update friends set email = 'rizwan@example.com' where id = 4; /*deleting a roe from friends*/ delete from friends where id = 1; select * from friends; /*adding a column*/ alter table friends add deathday text; select * from friends; /*droping the entire table*/ drop table friends; /*this shows table has been dropped*/ select * from friends;
run
|
edit
|
history
|
help
0
Employee Table
table emp
tables creation
kuy09:admin09@pkms99.info
Shalvika's Query
Trim numbers
Preppin Data Challenge - Week 9
database size
Performance test - select vs while - Get all days between two dates.
Mala Studentska sve