Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
20181cse0012dbmsca2
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table shop(shop_id int primary key,shop_name varchar(13),phone_number varchar(10),email varchar(19),city varchar(11),state varchar(11)); insert into shop values(20201,'lulu','8263719473','lulubazaar@yahoo.in','bengaluru','karnataka'); select * from shop; insert into shop values(20202,'royalmart','4656073560','royalmart@gmail.com','mysuru','karnataka'); insert into shop values(20203,'biggbazaar','5359385409','bigg@outlook.in','pune','maharashtra'); insert into shop values(20204,'ajfan','5738349583','ajfan@hotmail.com','nizamabad','telangana'); insert into shop values(20205,'landmark','8263719473','custsup@landmark.in','chennai','tamilnadu'); select * from shop; create table staff(staff_id int primary key,staff_name varchar(12),email varchar(19),shop_id
run
|
edit
|
history
|
help
0
program2
DeletorWall
28-02 3
Demo
MyShopSchema
STDEV vs STDEVP
Practice
SQL Stringdata
tp3
Demo