Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Incorrect Syntax near ';'

Author  Topic 

jsc0624
Starting Member

13 Posts

Posted - 2007-04-25 : 01:18:17
I dont have any idea why this code won't work?

create table tblSiteName (
SiteNameID int not null,
SiteName char(100),
Primary Key (SiteNameID));


The error says: Incorrect syntax near ';'.



===============
JSC0624
===============

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-25 : 01:47:05
looks fine to me. Tried removing the ';' ?


KH

Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-25 : 03:42:24
If this statement is part of bigger block of code, you may be looking at the wrong place. Post complete code so that somebody can point out the actual error.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -