SQL Queries practice thread

[maaditenali]

[quote author=HAPPYNESS link=topic=201842.msg2465139#msg2465139 date=1307903035]
chesa  :0012391: :0012391: :0012391: :0012391: :0012391: :0012391:
[/quote]
[img]http://www.bewarsetalk.net/discus/movieanimated4/bemmi1.gif[/img] choosaa...

[king420]

[quote author=GAJADONGA GANGULU link=topic=201842.msg2465207#msg2465207 date=1307904190]
[img]http://www.bewarsetalk.net/discus/movieanimated4/bemmi1.gif[/img] choosaa...
[/quote] *u( *u( *u( *u( *u( *u( *u( *u(

[C Nation]

[quote author=HAPPYNESS link=topic=201842.msg2465067#msg2465067 date=1307902018]
select girls from people_in_world where age > 21 and age < 25 and color = white and beauty = high;  &D_@@ &D_@@ &D_@@ &D_@@ &D_@@
[/quote]father = rich ani kooda add cheseyyi baaa. adhi okkati enduku vadaladam.  @3$% @3$%

[sombarey]

insert chese tym lo multiple  ga valuse oke sari ivva vachaa rather than giving values to each row one time

oke saari rows annitiki ichi run cheyali ante elaa  CITI#H@ CITI#H@

[sombarey]

[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]

ee values anni oke  saari  ichi run cheyatam  kuduruthundaa

[C Nation]

[quote author=patriot link=topic=201842.msg2466531#msg2466531 date=1307930410]
ee values anni oke  saari  ichi run cheyatam  kuduruthundaa
[/quote]
insert statement tharuvatha GO ani command ichi inko insert statement run cheyyochu.

[king420]

[quote author=patriot link=topic=201842.msg2466531#msg2466531 date=1307930410]
ee values anni oke  saari  ichi run cheyatam  kuduruthundaa
[/quote] each person ki diffferent ID unnapudu different salary unnappudu ela istav baa single Insert lo  *7*^ *7*^ *7*^

C sharp lo ayete code raychemo ID incriment by +1 ani...

[sombarey]

[quote author=C Nation link=topic=201842.msg2466553#msg2466553 date=1307931038]
insert statement tharuvatha GO ani command ichi inko insert statement run cheyyochu.
[/quote]

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

inthe na baa nuvvu anedi

ila isthunte its saying sql command not properly ended antundi

[sombarey]

[quote author=HAPPYNESS link=topic=201842.msg2466573#msg2466573 date=1307931471]
each person ki diffferent ID unnapudu different salary unnappudu ela istav baa single Insert lo  *7*^ *7*^ *7*^

C sharp lo ayete code raychemo ID incriment by +1 ani...
[/quote]

ippudu ekkuva data ni inset cheyali anukoo baa some 1000 rows vunnadi

daniki 1000 tyms insert ani ivva lemu kada.. then how ani

[C Nation]

[quote author=patriot link=topic=201842.msg2466577#msg2466577 date=1307931662]
insert into emptest values(100,'CHITTINAI DU','10000')
go
insert into emptest values(200,'PSYCHOPK','23000')
go
insert into emptest values(102,'HANGOVER','3400')
go
insert into emptest values(104,'WOLVERINE','1340')
go
insert into emptest values(102,'PATRIOT','56700')
go
insert into emptest values(130,'MBA','3400')
go
insert into emptest values(150,'CHARYGARU','6700')
go
insert into emptest values(170,'AMMULU','100')

inthe na baa nuvvu anedi

ila isthunte its saying sql command not properly ended antundi
[/quote]
yupe.
idhi work avvali. enduku avvadam ledhu  sCo_^Y sCo_^Y sCo_^Y
i will check it tommorow baa. naa lappy sql ledhu.  H&*() H&*()

[C Nation]

[quote author=patriot link=topic=201842.msg2466580#msg2466580 date=1307931749]
ippudu ekkuva data ni inset cheyali anukoo baa some 1000 rows vunnadi

daniki 1000 tyms insert ani ivva lemu kada.. then how ani
[/quote]hmmm
1000 rows values aithe kavali kada baaa.

ippudu table1 lo unna 1000 rows table2 lo ki dump cheyyali ante

insert into table2(col1,col2,col3)
select top 1000 col1,col2,col3 from table1


paina query table1 lo unna top 1000 rows table2 lo ki dump chesthundi.

incase nuvvu diff scenaria gurunchi aduguthunte aa scenario endo cheppu.  H&*() H&*()

[C Nation]

[url=http://blog.sqlauthority.com/2007/06/08/sql-server-insert-multiple-records-using-one-insert-statement-use-of-union-all/]http://blog.sqlauthority.com/2007/06/08/sql-server-insert-multiple-records-using-one-insert-statement-use-of-union-all/[/url]

[sombarey]

[quote author=C Nation link=topic=201842.msg2466596#msg2466596 date=1307932327]
yupe.
idhi work avvali. enduku avvadam ledhu  sCo_^Y sCo_^Y sCo_^Y
i will check it tommorow baa. naa lappy sql ledhu.  H&*() H&*()
[/quote]
thankyou baa oopikaga maa tution sir laa samaadaanam septhunnavu baa  you rock you rock H&*()

[C Nation]

[quote author=patriot link=topic=201842.msg2466617#msg2466617 date=1307933087]
thankyou baa oopikaga maa tution sir laa samaadaanam septhunnavu baa  you rock you rock H&*()
[/quote]sql meedha disco's ante istham baa. maa apees lo mamalni database lu muttaneeyaru.

[Gachibowli_Diwakar]

[quote author=patriot link=topic=201842.msg2466617#msg2466617 date=1307933087]
thankyou baa oopikaga maa tution sir laa samaadaanam septhunnavu baa  you rock you rock H&*()
[/quote]evaraina explain chesthe niku aah okka issue ne telusthundi .. incase niku nuvve telusukovali ani try chesaav anuko.. U will get to know many other  things related to that topic  H&*() H&*()

so keep trying ba .. u'll definetly find the required