whats wrong with this statement for sql server to create a table?

SQL Server accepts the usage of '-' Hyphen in the column names, but has to be wrapped in the delimiter Double Quotation Marks (") or Square Brackets ([ ]).

This wrapping is needed because the normal specification for column naming conventions doesn't contain the usage of Hyphen.

So, to make your create table script work -

CREATE TABLE Pub_Pool_Leauge

(

"E-mail" nchar(70)

)

OR

CREATE TABLE Pub_Pool_Leauge

(

[E-mail] nchar(70)

)

Be aware of the fact that, every time a reference happens to this column it has to be enclosed in these delimiters.

SELECT [E-mail] FROM Pub_Pool_Leauge;

SELECT "E-mail" FROM Pub_Pool_Leauge;

-- In 'thoughts'...

Lonely Rogue.

https://twitter.com/#!/LonelyRogue

Use

"E-mail" nchar(70)

instead of

E-mail nchar(70)

EDIT: i'm sorry, I made a mistake This one ought to artwork mysql_query(' CREATE table `watchlist`( `username` VARCHAR(16) no longer NULL, `offence` textual content no longer NULL, `punishment` textual content no longer NULL, popular KEY (`username`) ) ') or die (mysql_error());

1. You shouldn't be using - for e-mail rather use underscore as e_mail

2. if it is MS Sql server you shouldn't be using length for int ,because in it the length is dynamically associated as needed.

You can't use a (-) sign because it thinks it's a minus operator.