Sql Script error in SQL 2008 Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '.'.

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

Hi there.

I get the following error on my SQL manager when I want to run a script.

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '.'.

Below is the Script.

use eqcas
SELECT cat_validation.name, cat_validation.description, cas_user_ext.email cat_validation.primarypin FROM eqcas.dbo.cas_user_ext cas_user_ext, eqcas.dbo.cat_validation cat_validation WHERE cat_validation.id = cas_user_ext.x_id AND ((cat_validation.expiration Is Null)) Go

What could be the problem?

Posted 13-Jun-13 23:18pm

John Wayne52

Add a Solution

Comments

Surendra Adhikari SA 14-Jun-13 5:20am

can you show your table structure??

John Wayne52 14-Jun-13 5:32am

I get this error afterward.

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'Go'.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-06-13T23:20:00

Solution 1

You missed a comma:

SQL

SELECT cat_validation.name, cat_validation.description, cas_user_ext.email cat_validation.primarypin FROM

Becomes

SQL

SELECT cat_validation.name, cat_validation.description, cas_user_ext.email, cat_validation.primarypin FROM

Posted 13-Jun-13 23:20pm

OriginalGriff

Comments

John Wayne52 14-Jun-13 5:23am

I get this error afterward.

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'Go'.

OriginalGriff 14-Jun-13 5:39am

Take out the "Go" - you don't need it. Also, why have you used two sets of brackets? Especially as you don't need any?

John Wayne52 14-Jun-13 5:50am

Thanks so much!

OriginalGriff 14-Jun-13 6:15am

You're welcome!

Monjurul Habib 16-Jun-13 15:57pm

5+