Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
ss sqlpractice2014
--Sql Server 2014 Express Edition --Batches are separated by 'go' create table Employee(Emp_id int identity(1,1), Emp_name varchar(20), Dob datetime, Age int check(age>18 and age<58), city varchar(20) check (city in ('Chennai','Bangalore','Pune','Hyderabad')), Design varchar(20) not null, salary money) insert into Employee values('Arun','07/09/1982',25,'Chennai','Analyst',21000) insert into Employee values('Arvind','12/10/1980',21,'Pune','Analyst',21000) insert into Employee values('Arnab','1/8/1978',40,'Pune','Analyst',21000) insert into Employee values('Ajit','01/01/1992',20,'Chennai','Analyst',21000) select * from Employee update Employee set age=26 where Emp_id = 1 select * from Employee delete Employee where Emp_id = 1 select * from Employee drop table Employee select * from Employee create table Employee(Emp_id int identity(1,1), Emp_name varchar(20), Dob datetime, Age int check(age>18 and age<58), city varchar(20) check (city in ('Chennai','Bangalore','Pune','Hyderabad')), Design varchar(20) not null, salary money) truncate table Employee create table Employee1(Emp_id int identity(1,1), Emp_name varchar(20), Dob datetime, Age int check(age>18 and age<58), city varchar(20) check (city in ('Chennai','Bangalore','Pune','Hyderabad')), Design varchar(20) not null, salary money) sp_help Employee
run
|
edit
|
history
|
help
0
20181117
Campeonato 3 bilhoes
SQL - Find series of timestamps with small gaps
SQL Server Mistique!?
Task_5_Final
SqlServer1282018
Stuff
Pro DB's project
Libros
jueves