T-SQL in SQL Express 2005 | Student Union

dazzledesign

Hi,
I am trying to execute following T-SQL query in SQL 2005 Express, but it throws an error 'Incorrect Syntax near GO'

Can anyone please tell why?

SELECT *
FROM Integers;
GO

Thanks

Cupiditas
Chris Hawkins

Why do you have a semi-colon? Remove it and I'm sure you'll find that query runs fine.

dazzledesign

In reply to Cupiditas

#Jan 2nd @ 5:18 PM

Hi,

I tried removing the semi colon - but still it does not work

Why?

Cupiditas
Chris Hawkins

In reply to dazzledesign

#Jan 2nd @ 11:43 PM

Well, for that matter, it'll work without the 'Go', as well.

dazzledesign

In reply to Cupiditas

#Jan 3rd @ 6:33 PM

Hi,
GO is a batch command and is used to execute BLOCKS of T-SQL statements

Why does SQL Server 2005 not recognize GO Command?

Griffin

In reply to dazzledesign

#Jan 7th @ 3:07 AM

SQL 2005 does recoginize the go command. I use it all the time.

If you look at the Error I think it was throwing a fit with the Semicolon. Oracle I know uses Semi-colons after their statements

I tried a query similar to yours on my Database and it worked fine. Although I was using a SQL 2005 available through Dreamspark.

Cupiditas
Chris Hawkins

In reply to dazzledesign

#Jan 7th @ 3:07 AM

It does recognise Go command, but it's not necessary when you're executing a single select query like that, and if there's an error the first thing you should do is strip extraneous commands from your statement.

I'm with Griffin, the semi-colon must be the problem, and if you think removing it didn't solve anything then I really have no idea.

In reply to {0}

Download:[Pending]

In reply to {0}

Download:[Pending]