General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>Hello all
>
>ok, it's been a while since I had to deal with straight T-SQL and I'm trying to create a table
>
>Create table CATMaster (CATID int identity(1,1), Category varchar(2), diff varchar(1), ALC varchar(5), Keyword varchar(25),
> Keyword2 Varchar(25), keyopt varchar(1), script varchar(500), stem varchar(500), respa varchar(115),
> respb varchar(115),respc varchar(115), respd varchar(115), scripttime varchar(2), testtype varchar(1),
> EntBy VarChar(3), EntDate date, RevBy Varchar(3), RevDate date, Completed varchar(1)
>
>It keeps telling me "The specified data type is not valid. [ Data type (if known) = varchar ]"
>
>Ok, I'm confused. What am I not seeing?
>
>Thanks
You have to be fast to get a solution credit here, LOL. You left out the closing brace....
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only