Message
From
13/06/2008 10:09:33
To
13/06/2008 10:03:42
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323801
Message ID:
01323808
Views:
19
>I get an error on the WorkPhone column that is doesn't like the quotes. How do I create an empty column?
>
>
It's usually easier to create tables in the designer and then just script them.
>
>
> [Phone] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, > '' AS WorkPhone, >
select *, cast('' as varchar(12)) as WorkPhone from Peopleif you need this in the SELECT-SQL.
It's usually easier to create tables in the designer and then just script them.