problem creating insert Query

Teradata Studio

problem creating insert Query

Hi fri,

            i ran one Query. it shows into the few records. i want to those records will convert to insert/select statemt. is there any op`tion in TD12.

           suppose oracle Developer willl have a option like insert/create/update for auto matically preparing the queries. is there any option could please tell me. In one senerion we have to require that type of opption.

Teradata Employee

Re: problem creating insert Query

Teradata provides an INSERT/SELECT statement. Teradata Studio provides an INSERT/SELECT template in the SQL Editor. In the SQL Editor, at the beginning of a line, type in the word INSERT then enter CTRL+SPACE and a pop up list of INSERT templates is provided.