Error encountered when creating table with MS SQL and Visual Studio

Asked By MannyG 0 points N/A Posted on - 11/04/2011

Hi Experts,

I am new to MS SQL and I am using it with Visual Studio 2005.  I was developing a simple system and tried creating a table but then I got this error message, see below.  I have searched the web but couldn’t find a suitable answer.  Any help I can get from the forum experts?  Help will be much appreciated.

Query Definitions Differ

The following errors were encountered while parsing the contents of the SQL pane:

The CREATE TABLE SQL construct or statement is not supported

The query cannot be represented graphically in the Diagram and Criteria Pane.

• Status: Open
• Question Views: 2608
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: ProgScripting Languages

Answered By Mahesh Babu 20 points N/A #105350

Error encountered when creating table with MS SQL and Visual Studio

Hallo MannyG,

The problem you are experiencing might be as a result of the version of the visual studio edition that you are currently using. If the version that you have if the visual studio express edition, then that may be the cause and therefore I will advise that you try the other versions.

But if you are open to using other applications that will perform the same functions as the visual studio application, I will recommend the SQL server management studio which offers best features when it comes to control of the database.

Otherwise, the error may be in the syntax, especially if you are writing the code by hand as opposed to using the designer view, check the syntax of the SQL and ensure that it is not wrongly written.

___

Regards
Mahesh Babu

 

 

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/21/2011
• Question Category: ProgScripting Languages