serinor.e090266 (3/27/2009)

---

I dont know if there is a problem, but i have tested the sentence in a SQL Server 2005

More information:
1)
Output for SELECT @@VERSION

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2) See the attached document.


This server is 2005 or not?

serinor.e090266 (3/27/2009)

---

I dont know if there is a problem, but i have tested the sentence in a SQL Server 2005

More information:
1)
Output for SELECT @@VERSION

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2) See the attached document.


This server is 2005 or not?

Vijaya Kadiyala (4/1/2009)

---

My Asnwer is perfectly valid i.e will display 1..6.. if we execute this query in 2000.

We should have this question specific to the SQL Server version.

Thanks -- Vijaya Kadiyala
www.dotnetvj.vom

Julie Breutzmann (3/26/2009)

---

While the question and answer were not ideal, this question was valuable to me because I learned so much from the discussion that followed.

Select 1
union Select 2
union Select 3
union Select 4
union Select 5
union Select 6
union Select 7
UNION Select 'A'
union Select 'B'
union Select 'C'
union Select 'D'

Server: Msg 245, Level 16, State 1, Line 1
Syntax error converting the varchar value 'A' to a column of data type int.

Create Table Test(col varchar(10))
GO
Insert into Test
Select 1
union Select 2
union Select 3
union Select 4
union Select 5
union Select 6
union Select 7
UNION Select 'A'
union Select 'B'
union Select 'C'
union Select 'D'

(11 row(s) affected)