18.1.10

SQL Query challenge

Hi Readers,

Have you tried inserting a record in the table like below,

create table Venkattemp (id int identity(1,1))

Any inputs????????

Thanks and Regards,
Venkatesan Prabu .J
at

2 comments:

  1. MadhivananJanuary 18, 2010 at 10:45 PM

    It should be

    Insert into Venkattemp default values

    http://sqlblogcasts.com/blogs/madhivanan

    ReplyDelete
  2. Vijaya KadiyalaJanuary 20, 2010 at 12:42 PM

    Hi Venkat
    This is a good question. The Answer is

    insert into Venkattemp default values;

    Thanks -- Vijaya Kadiyala
    www.DotNetVJ.com

    ReplyDelete