If I do
SELECT TOP 25 * FROM table ORDER BY id
does it select any 25 records and then order them
or does it SELECT all the records, order them by ID then return the

Sono in procinto di passare da access a sql server, per ora passando
solo il db in sql server e collegando le tabelle in access per sfruttare
tutte le maschere che ho già, sperando così dover fare poche modifiche e
che funzioni tutto presto.

   I'm sure this has come up for people before.  I have two fields in one
table that both refer to my users table.
TakenByID
EnteredByID

Someone renamed a server from 2A to A.
When I do @@servername I get 2A.
The server/machine name is 2.
Should my triggers say 2A or 2?  Does it matter?

Can someone help me fix my query?    In the results, if there is a "Regimen"
for the selected DPID I don't want to see a "NULL" record for the same
Regimen.     Here's what I'm getting:
     DPID

I am absolute a novice in XML but need to shred XML into SQL Server
2005.
I studied some examples, but only with simple XML Docs.
My docs seems to be looking more complex.

I'm having trouble running TSQL commands when SQL2005 is in single-
user mode.
I've restarted SQL with -m, -c, -T3608 set in the startup options.
I can get into Config manager OK, but as soon as I try to start a New

I'm still designing and thinking about security for an app being converted
from Access. I'm new to SQL Server and very ignorant.  Could someone with
more experience please give me their thoughts on Application Roles.  Seems
to me they are useful in one important way.. it doesn't ...

I've been using SQL Server 2000 and am not familiar with all the new
features in 2005 but I understand it has the ability to make web
service calls.
Is there a way to write a stored procedure that passes street/city/

Is there a client for SQL Server 2005 that will run on NT4, or Linux?  I only
need to run some simple SELECT queries.
If not, is the NT mssqlserver ODBC driver compatible?
Thank you.

I have a simple "select * from TABLENAME" sp that works fine.
How can I call it with DAO and get a recordset.
Everything I try fails.
(Please note) usin\g ADO is not a practical option.

Hi - I'm not sure if this is the correct forum for this question.  If it
isn't I'd be grateful if someone could direct me to the right one.
Meanwhile, here goes ...
I'm converting an old Access app to SQL, and upgrading the front end to

hi, all.
I want to verify data merged from access in sqlserver.but it has too
many records .so i need a tool
do this.

how ?

At:-
http://groups.google.co.uk/group/microsoft.public.sqlserver.programming/browse_t
hread/thread/296fcecdbdd5eabf/be1629eaa918d882?lnk=st&q=dataphor+ADO#be1629eaa91
8d882
Steve Dassin says:-
"If you are truely a beginner then your brain hasn't been filled with