Insert query

• Shazz

  SSC Rookie

  Points: 33

  More actions

  October 11, 2008 at 12:18 am

  #194544

  Hello all

  I am writing query as

  create table tbl

  ( name as varchar2 not null )

  insert into tbl

  (

  Select name from account

  union

  Select name from customer

  union

  Select name from party

  )

  system gives me error.

  Please guide me am i writing wrong query or system donot permit insert using 'union or union all' query.

  Please help...

• dva2007

  SSCertifiable

  Points: 7707

  More actions

  October 11, 2008 at 4:06 am

  #883742

  hi,

  i think it might be that ur name field u said is not null...try to declare it as null....i dont have sql server installed at home...so cant test...sorry....just try....

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  October 12, 2008 at 10:22 pm

  #883968

  VARCHAR2 is not a valid data type in SQL Server.

  Try the following

  create table tbl (

  name as varchar(50) not null

  )

  GO

  insert into tbl (name)

  Select name from account union

  Select name from customer union

  Select name from party

  .