April 22, 2009 at 6:24 am
Table:Temp
OwnerName/FatherName/RationCardnO
Aakula Anjaiah S/o Veeraiah Wap 6825011205 Aakula Sada Nandam S/o Veeraiah Aakula Veeraiah S/o Bhumaiah Wap Aakula Shivadeenam S/o Veeraiah Wap 7825011257
Sayad Ajimuddin S/o Bhasumiya Wap 6825010014 Shaik Shassina Begam W/o Moulana Wap 1883913037 Syed Alina W/o Bhasu Wap 883910321 Syed Nabhi S/o Bhasu Syed Mahaboob Ali S/o Bhasu Wap 3839130147 Syed Ali S/o Bhasumiya
I had Temp Table with one column as OwnerName/FatherName/RationCardnO
I want to insert above values into 3 fields of Temp1 table
my Temp1 table as 3 columns
OwnerName
FatherName
RationCardNo
Plz give me q query to insert
April 22, 2009 at 6:35 am
OwnerName/FatherName/RationCardnO
Aakula Anjaiah S/o Veeraiah Wap 6825011205 Aakula Sada Nandam S/o Veeraiah Aakula Veeraiah S/o Bhumaiah Wap Aakula Shivadeenam S/o Veeraiah Wap 7825011257
Sayad Ajimuddin S/o Bhasumiya Wap 6825010014 Shaik Shassina Begam W/o Moulana Wap 1883913037 Syed Alina W/o Bhasu Wap 883910321 Syed Nabhi S/o Bhasu Syed Mahaboob Ali S/o Bhasu Wap 3839130147 Syed Ali S/o Bhasumiya
I had Temp Table with one column as OwnerName/FatherName/RationCardnO
Please specify the values for "OwnerName". "FatherName", "RationCardnO" in above lines. Can you differentiate them any how?
"Don't limit your challenges, challenge your limits"
April 22, 2009 at 6:36 am
insert into #TempTable (OwnerName, FatherName, RationCardnO)
values ('Aakula Anjaiah','Veeraiah Wap','6825011205')
And so on, for each set of values.
Is that what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply