Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create empty column in results
Message
From
13/06/2008 10:23:15
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323801
Message ID:
01323820
Views:
14
>>I get an error on the WorkPhone column that is doesn't like the quotes. How do I create an empty column?
>>
>>
>>	[Phone] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
>>	'' AS WorkPhone,
>>
>
>workphone varchar(20) DEFAULT '' NOT NULL
	Reserved01 varchar(20) DEFAULT '' NOT NULL,
Error:
Msg 102, Level 15, State 1, Line 27
Incorrect syntax near ')'.
Previous
Reply
Map
View

Click here to load this message in the networking platform