Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Table syntax
Message
 
 
To
04/06/2012 10:47:23
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01545225
Message ID:
01545243
Views:
42
>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
Map
View

Click here to load this message in the networking platform