Prev: alternative of xp_smtp_sendmail in sql server 2008
Next: SQL Server 2000, Non-Clustered Index Creation and Blocking
From: jodleren on 19 Apr 2010 11:14
Hi all

We have some intranet thing, which needs to be transferred from MS
Access to SQL server.

I have serious problems with fieldnames and tablenames with spaces,
and using SQL Explorer is even hard.

MS SQL Server can import from MS Access, but I cannot see into certain
tables without SQL Explorer simply crashing.

E.g. How do I translate this into MS SQL?
select top 1 job.[CAM File],[material], job.[description] from job
where job.[CAM file] <> ""

I am wondering whether to rename a lot of tables and fields.

BTW, why does "select * from job" makes the system crash?
I mean, what can go wrong in importing data?
Something must be very different in the structures of the system (yes,
but what?)

Sonnich
From: Patrice on 19 Apr 2010 11:40
Hi,

The error being ? SQL Server uses also []. Note thought that it uses singles
quotes ( ie where job.[CAM file]<>'')

Always give the exact error you get. I'm not sure also what you call "SQL
Explorer" (is this SQL Server Management Studio ?).

--
Patrice


"jodleren" <sonnich(a)hot.ee> a �crit dans le message de
news:542884bb-7e77-4572-ac1a-82f450ac8e4e(a)e7g2000yqf.googlegroups.com...
> Hi all
>
> We have some intranet thing, which needs to be transferred from MS
> Access to SQL server.
>
> I have serious problems with fieldnames and tablenames with spaces,
> and using SQL Explorer is even hard.
>
> MS SQL Server can import from MS Access, but I cannot see into certain
> tables without SQL Explorer simply crashing.
>
> E.g. How do I translate this into MS SQL?
> select top 1 job.[CAM File],[material], job.[description] from job
> where job.[CAM file] <> ""
>
> I am wondering whether to rename a lot of tables and fields.
>
> BTW, why does "select * from job" makes the system crash?
> I mean, what can go wrong in importing data?
> Something must be very different in the structures of the system (yes,
> but what?)
>
> Sonnich

From: Philipp Post on 20 Apr 2010 07:41
> I have serious problems with fieldnames and tablenames with spaces, and using SQL Explorer is even hard. <

You might want to use SQL Server Management Studio from Microsoft
instead of the Borland tool. It comes with SQL Server. If you do not
have it, a copy of the express (free) version can be downloaded from
the Microsoft download center.

brgds

Philipp Post
 | 
Pages: 1
Prev: alternative of xp_smtp_sendmail in sql server 2008
Next: SQL Server 2000, Non-Clustered Index Creation and Blocking