Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
SS my sql server 2014 4/7
--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',19,'Pune','Analyst',21000) insert into Employee values('Arnab','1/8/1978',40,'Pune','Analyst',21000) insert into Employee values('Ajit','01/01/1992',50,'Chennai','Analyst',21000) select * from Employee alter table Employee alter column
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
SS Sqlsvr2014 practice
Transpose group per sequence
Grouping, aggregate function issue when joining to another table
MSSQL NVARCHAR to INT conversions
persons
tr3
Stored procedure ex1
Where clause inside sub query
Remove duplicates with in 10 min
identity
stackse - search stackoverflow differently
Please log in to post a comment.