PDA

Click to See Complete Forum and Search --> : Query Not Working


Arrow_Raider
Jan 25th, 2003, 05:17 PM
I am trying to runt he following query:

CREATE TABLE [Drivers]
([IDnum] Integer PRIMARY KEY IDENTITY(1,1),
[Team] Variant,
[Week] Integer,
[Driver] text,
[Points Earned] Integer,
[Finished] Integer)

I recieve this error:
Column or parameter #2: Cannot find data type Variant.

This makes no sense, variant is a datatype.

Lethal
Jan 26th, 2003, 01:07 AM
Variant is not a datatype in sql server..

Arrow_Raider
Jan 26th, 2003, 08:10 AM
I already found out the problem, i had tried sqlvariant earlier and it didn't work and then i tried variant and it didn't work, what does work is sql_variant