Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
create table with constraunt
create table student ( stuid int primary key, Name varchar(255), Address varchar(255), State varchar(255) default 'xyz', mobileNo int unique, Age int not null ); insert into student(stuid, Name, Address, mobileNo, Age) values(1, 'Gaurav Thakur', 'shimla', 65767687, 32) insert into student(stuid, Name, Address, mobileNo, Age) values(2, 'Anita Thakur', 'shimla', 6576776, 29) insert into student(stuid, Name, Address, mobileNo, Age) values(3, 'Bavita Thakur', 'shimla', 665767687, 22) select * from student
run
|
edit
|
history
|
help
0
Performance test - select vs while - Get all days between two dates.
Lisber-SQL-Example(CASE)
Fatch data in xml format
performance on update using subquery versus correlated update
BC160400549
student
#Temp Table fill
1512081 QUAN LY DE TAI
Comercio
SQL Server - UK Holiday Calendar Example