create table abcde(id int identity, name varchar(20)default 'abcd')

• Nagaram

  SSCrazy

  Points: 2110

  More actions

  November 17, 2010 at 10:26 pm

  #231720

  create table abcde(id int identity, name varchar(20)default 'abcd')

  how can i insert values like following

  1 abcd

  2 abcd

  3 abcd

  4 abcd

  like....

  with out using "insert into abcd values('abcd')" .....

  can anyone explain please this scenario .

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  November 17, 2010 at 10:37 pm

  #1252278

  You can use

  INSERT INTO abcde VALUES ( default )

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Nagaram

  SSCrazy

  Points: 2110

  More actions

  November 17, 2010 at 10:45 pm

  #1252281

  Thank u