Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-08-17 : 09:20:57
|
| Hi iam having a table abcin that fields are name,district,state, i want to insert into the table as rajasekhar,prakasam,A.P mahesh,prakasam,A.P kishore,prakasam,A.Pi want a stored procedure or one function to do so.can anyone help me out in doing such.in database it can be stored as like that. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-08-17 : 09:24:29
|
| insert into abcselect 'rajasekhar','prakasam','A.P' union select 'mahesh','prakasam','A.P' unionselect 'kishore','prakasam','A.P'Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2009-08-17 : 09:30:45
|
| how can i do it in oracle.any idea |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-08-17 : 10:28:19
|
| u can use senthil query in oracle also. |
|
|
|
|
|
|
|
|
insertion with multiple values