I'm unsure what's wrong when I declare these variables in SQL
sql, sql-server-2008
Solution
DOUBLE is not a valid datatype in sql server
Use float, numeric, ... or any of the other types that are supported.
More info at http://msdn.microsoft.com/en-us/library/ms187752.aspx
Problem
I have the following code: ``` USE pricingdb go CREATE TABLE dbo.Events_060107_2012 ( Date_Time varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, Event_Type TEXT, Month_of_Year TEXT, Survey DOUBLE, Actual DOUBLE, Prior_Data DOUBLE, Revised DOUBLE, Relevance FLOAT, Ticker TEXT ); ``` Go And I'm getting an Error: ``` "Incorrect syntax near ','. Level 15, State 1, Line 6" ``` I'm aware that this should be a pretty easy problem to fix, but for whatever reason I'm having a lot of trouble understanding how to go about fixing this. My knowledge of SQL is beginner at best, so most of the other threads I read were a little above my head. Thanks in advance for any help.