Insert query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Insert query

Insert query

Rate Topic

Display Mode

Topic Options

Author

Message

Shazz

Posted Saturday, October 11, 2008 12:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, October 11, 2008 12:09 AM
Points: 3, Visits: 7

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...

Post #584345

dva2007

Posted Saturday, October 11, 2008 4:06 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:05 AM
Points: 530, Visits: 1,020

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....

Post #584365

jacob sebastian

Posted Sunday, October 12, 2008 10:22 PM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

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

Post #584647

« Prev Topic | Next Topic »

Permissions