Re: INSERT QUERY

Its all ways better to use integers without quotes. It would effect execution plan of the sql.

regards
anandkl

On 8/29/07, Krishna Chandra Prajapati <prajapatikc@gmail.com> wrote:
>
> hi all,
>
> create table stu (name varchar(20), roll int(2), id decimal(2));
>
> insert into stu values ('krishna', '25', '25');
> insert into stu values ('krishna', 25, 25);
>
> The above two queries are working properly.
> my question is whether it is going to impact in future.
> Integer and decimal values in quotes (') and without quotes makes any
> difference.
> Normally which format should be used.
>
> Regards,
> Krishna
>
Received on Wed Aug 29 06:22:46 2007