SQL Queries practice thread

[king420]

Use Practice1
Go
create table emptest(empno int,enam varchar(20),basic int)

F%G_@ F%G_@ F%G_@ F%G_@

[sombarey]

*=: *=: *=: you rock thankyou

[Chocolateboy]

*=: *=: *=: *=:

[Dupe]

DROP TABLE emptest;

table is deleted and thread is closed.  #4H# #4H# #4H#

[king420]

insert into emptest values(100,'CHITTINAIDU','10000')
insert into emptest values(200,'PSYCHOPK','23000')
insert into emptest values(102,'HANGOVER','3400')
insert into emptest values(104,'WOLVERINE','1340')
insert into emptest values(102,'PATRIOT','56700')
insert into emptest values(130,'MBA','3400')
insert into emptest values(150,'CHARYGARU','6700')
insert into emptest values(170,'AMMULU','100')

[king420]

[quote author=odiyam link=topic=201842.msg2462142#msg2462142 date=1307811936]
DROP TABLE emptest;

table is deleted and thread is closed.  #4H# #4H# #4H#
[/quote] madhyalo evadanna disturn cheste [img]http://www.desigifs.com/sites/default/files/20zwfgn.gif?1290167532[/img]

[king420]

[quote author=HAPPYNESS link=topic=201842.msg2462127#msg2462127 date=1307811638]
Use Practice1
Go
create table emptest(empno int,enam varchar(20),basic int)

F%G_@ F%G_@ F%G_@ F%G_@
[/quote] In this table we dont have any constraints created.  sCo_^Y sCo_^Y sCo_^Y sCo_^Y
  Let Us try with different constraints

[satti from attili]

&D_@@ &D_@@ &D_@@ &D_@@

[king420]

CREATE TABLE EMPTEST1 (ID INT CONSTRAINT PK1 PRIMARY KEY,DEPT VARCHAR(20) CONSTRAINT CK20 CHECK(DEPT IN('CS','ES','RD')),SALARY INT CONSTRAINT CK21 CHECK(SALARY BETWEEN 2000 AND 3000))    sCo_^Y sCo_^Y sCo_^Y sCo_^Y sCo_^Y

[erragulabi]

real time problems we face in configuring clustering, mirroring and replication.......
evaraikaina telisthe post cheyyandi.

[k2s]

sSa_j@il

[ugra naram]

~"!

[sombarey]

baa koncham joins meeda disco pedadama.. inner outer left  right

[vijay2349]

[quote author=HAPPYNESS link=topic=201842.msg2462144#msg2462144 date=1307811961]
insert into emptest values(100,'CHITTINAIDU','10000')
insert into emptest values(200,'PSYCHOPK','23000')
insert into emptest values(102,'HANGOVER','3400')
insert into emptest values(104,'WOLVERINE','1340')
insert into emptest values(102,'PATRIOT','56700')
insert into emptest values(130,'MBA','3400')
insert into emptest values(150,'CHARYGARU','6700')
insert into emptest values(170,'AMMULU','100')
[/quote]

baa mari nenu  s%H#

[chicago]

nenu septha joins inner join outer join full join