Silver_mani Posted June 1, 2012 Report Posted June 1, 2012 in a single sql statement , columns lo multile rows ela insert cheyali ...
LoveGuru Posted June 1, 2012 Report Posted June 1, 2012 [color=#00008B][background=transparent]INSERT[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]INTO[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]Table[/background][/color][background=transparent] [/background][background=transparent]([/background][background=transparent] Column1[/background][background=transparent],[/background][background=transparent] [/background][color=#00008B][background=transparent]Column[/background][/color][background=transparent] [/background][color=#800000][background=transparent]2[/background][/color][background=transparent] [/background][background=transparent])[/background][background=transparent] [/background][color=#00008B][background=transparent]VALUES[/background][/color] [background=transparent]([/background][background=transparent] Value1[/background][background=transparent],[/background][background=transparent] Value2 [/background][background=transparent]),[/background][background=transparent] [/background][background=transparent]([/background][background=transparent] Value1[/background][background=transparent],[/background][background=transparent] Value2 [/background][background=transparent])[/background]
Silver_mani Posted June 1, 2012 Author Report Posted June 1, 2012 [quote name='LoveGuru' timestamp='1338512697' post='1301891601'] [color=#00008B][background=transparent]INSERT[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]INTO[/background][/color][background=transparent] [/background][color=#00008B][background=transparent]Table[/background][/color][background=transparent] [/background][background=transparent]([/background][background=transparent] Column1[/background][background=transparent],[/background][background=transparent] [/background][color=#00008B][background=transparent]Column[/background][/color][background=transparent] [/background][color=#800000][background=transparent]2[/background][/color][background=transparent] [/background][background=transparent])[/background][background=transparent] [/background][color=#00008B][background=transparent]VALUES[/background][/color] [background=transparent]([/background][background=transparent] Value1[/background][background=transparent],[/background][background=transparent] Value2 [/background][background=transparent]),[/background][background=transparent] [/background][background=transparent]([/background][background=transparent] Value1[/background][background=transparent],[/background][background=transparent] Value2 [/background][background=transparent])[/background] [/quote] idi DB2, Sybase, teradata endulonu work avvatle mama
LoveGuru Posted June 1, 2012 Report Posted June 1, 2012 [quote name='Silver_mani' timestamp='1338512807' post='1301891612'] idi DB2, Sybase, teradata endulonu work avvatle mama [/quote] nenu sql server meeda work chestha so nenu e statement use chestha,so nee exact requirement cheppu nenu chebtha
Silver_mani Posted June 1, 2012 Author Report Posted June 1, 2012 [quote name='LoveGuru' timestamp='1338512869' post='1301891619'] nenu sql server meeda work chestha so nenu e statement use chestha,so nee exact requirement cheppu nenu chebtha [/quote] req ante em ledu mama .... oka table lo rows insert cheyali .... kani single insert statement lo multiple values support cheyyatledu
LoveGuru Posted June 1, 2012 Report Posted June 1, 2012 [quote name='Silver_mani' timestamp='1338513012' post='1301891627'] req ante em ledu mama .... oka table lo rows insert cheyali .... kani single insert statement lo multiple values support cheyyatledu [/quote] a table lo edhanna column meedha emanna constraints unnay emo check chesava
LoveGuru Posted June 1, 2012 Report Posted June 1, 2012 [color=#333333][font=arial][size=3]INSERT INTO <table_name> [/size][/font][/color] [color=#333333][font=arial][size=3]( [/size][/font][/color] [color=#333333][font=arial][size=3]FIELD1, [/size][/font][/color] [color=#333333][font=arial][size=3]FIELD2 [/size][/font][/color] [color=#333333][font=arial][size=3]) [/size][/font][/color] [color=#333333][font=arial][size=3]SELECT <field1_value1>, <field2_value1> [/size][/font][/color] [color=#333333][font=arial][size=3]UNION ALL [/size][/font][/color] [color=#333333][font=arial][size=3]SELECT <field1_value2>, <field2_value2> [/size][/font][/color] [color=#333333][font=arial][size=3]UNION ALL[/size][/font][/color] [font=arial][size=2][color=#333333]e style lo try chesava ,ekkado chadiva fast load script try chey [/color][/size][/font]
Silver_mani Posted June 1, 2012 Author Report Posted June 1, 2012 [quote name='LoveGuru' timestamp='1338513259' post='1301891642'] [color=#333333][font=arial][size=3]INSERT INTO <table_name> [/size][/font][/color] [color=#333333][font=arial][size=3]( [/size][/font][/color] [color=#333333][font=arial][size=3]FIELD1, [/size][/font][/color] [color=#333333][font=arial][size=3]FIELD2 [/size][/font][/color] [color=#333333][font=arial][size=3]) [/size][/font][/color] [color=#333333][font=arial][size=3]SELECT <field1_value1>, <field2_value1> [/size][/font][/color] [color=#333333][font=arial][size=3]UNION ALL [/size][/font][/color] [color=#333333][font=arial][size=3]SELECT <field1_value2>, <field2_value2> [/size][/font][/color] [color=#333333][font=arial][size=3]UNION ALL[/size][/font][/color] [font=arial][size=2][color=#333333]e style lo try chesava[/color][/size][/font] [/quote] try cheyaledu mama ...idi work avutadi anukunta kada
Vikkas Posted June 1, 2012 Report Posted June 1, 2012 [quote name='LoveGuru' timestamp='1338513259' post='1301891642'] [color=#333333][font=arial][size=3]INSERT INTO <table_name> [/size][/font][/color] [color=#333333][font=arial][size=3]( [/size][/font][/color] [color=#333333][font=arial][size=3]FIELD1, [/size][/font][/color] [color=#333333][font=arial][size=3]FIELD2 [/size][/font][/color] [color=#333333][font=arial][size=3]) [/size][/font][/color] [color=#333333][font=arial][size=3]SELECT <field1_value1>, <field2_value1> [/size][/font][/color] [color=#333333][font=arial][size=3]UNION ALL [/size][/font][/color] [color=#333333][font=arial][size=3]SELECT <field1_value2>, <field2_value2> [/size][/font][/color] [color=#333333][font=arial][size=3]UNION ALL[/size][/font][/color] [font=arial][size=2][color=#333333]e style lo try chesava ,ekkado chadiva fast load script try chey [/color][/size][/font] [/quote] gp. idhi work avuthundi
Silver_mani Posted June 1, 2012 Author Report Posted June 1, 2012 [quote name='@Shadow@' timestamp='1338513830' post='1301891672'] why dont you use stored procedure [/quote] one time use ki stored procedure enduku mama
@Shadow@ Posted June 1, 2012 Report Posted June 1, 2012 [quote name='Silver_mani' timestamp='1338513921' post='1301891676'] one time use ki stored procedure enduku mama [/quote] ohh one time use kaa.... .....nee question tharuvatha ardhamaindhi
Silver_mani Posted June 1, 2012 Author Report Posted June 1, 2012 [quote name='@Shadow@' timestamp='1338514077' post='1301891682'] ohh one time use kaa.... .....nee question tharuvatha ardhamaindhi [/quote] no prob mama
Cherry25 Posted June 1, 2012 Report Posted June 1, 2012 Oracle lo aite.. insert all into table_name values (fvalue1,fvalue2....) into table_name values (fvalue1,fvalue2....) . . . .select * from dual;
Silver_mani Posted June 1, 2012 Author Report Posted June 1, 2012 [quote name='Cherry25' timestamp='1338514521' post='1301891715'] Oracle lo aite.. insert all into table_name values (fvalue1,fvalue2....) into table_name values (fvalue1,fvalue2....) . . . .select * from dual; [/quote] select * from dual enti mama ?
Recommended Posts