SQL file made for 97 doesn't work for 2000

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

SQL Server 2000 Forums

Transact-SQL (2000)

SQL file made for 97 doesn't work for 2000

Author

Topic

1zippo1
Starting Member

4 Posts

Posted - 2004-06-28 : 10:49:43

Hey,

I was doing my internship in a company the last 2 months. Now it's finished but I had to come back, just to quickly install it on the server. They've just switched from 97 to 2000.

I thought, oh no problem at all. I suppose it just will be the same as with 97.

So I made a new DB, loaded the sql file and tried running it...
but it gives me an error at every single command I try to execute :-(

I'm really not in the mood to buy a new book or something, but I think a quick guidance by some people who know both 97 and 2000 might help me out a lot.

I'll just copy paste the first lines of the sql file:

DROP TABLE onderwerpT;

create table onderwerpT(onderwerpF varchar(40) unique not null);

INSERT INTO onderwerpT VALUES
("privé");

INSERT INTO onderwerpT
VALUES ("AS400 problemen");

INSERT INTO onderwerpT
VALUES ("Hardware probleem IT");

DROP TABLE afdelingT;

create table afdelingT(afdelingF varchar(40) unique not null);

INSERT INTO afdelingT
VALUES ("PDI");
...

The first error message:
The name 'privé' is not permitted in this context. Only Constants, expressions, or variables allowed here. Column names are not permitted.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2004-06-28 : 11:19:31

If you are talking about SQL server, use single quotes...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-28 : 14:13:15

Please post Access questions in the Access forum:

http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3

Tara

1zippo1
Starting Member

4 Posts

Posted - 2004-06-28 : 17:38:18

Hey again,

Aha, so single quotes instead of double might do the trick... I hope so. Thx for your response!!

And Tara, sorry for misposting it, I wasn't aware this was an acces question.

1zippo1
Starting Member

4 Posts

Posted - 2004-06-28 : 17:40:58

Oops, you mean Access as in the program Access, no no, I'm working with Microsoft Sql Server 2000...

Oh, no it hit me, it wasn't 97

I mean 7.0.

Sorry for all the confusion!

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-06-28 : 17:45:37

The single quotes should do the trick. It's probably trying to interpret the double quotes as a object instead of a literal value. I'd guess the setting for Quoted Identifier probably changed between your visits to the client.

-----------------------------------------------------
Words of Wisdom from AjarnMark, owner of Infoneering

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-28 : 17:45:59

Ah SQL Server 2000...

You can turn quoted_identifier off so that you can use double quotes.

set quoted_identifier off

then your code...

Tara

1zippo1
Starting Member

4 Posts

Posted - 2004-06-29 : 06:48:26

Thx guys, appreciate it. I'll let you know if it works

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources