Re: newbie question - local queries

Thanks for the advice. I was hoping that identifying myself as a
newbie would pretty much give the idea, that, I am a NEWBIE... I do
appreciate the advice very much.

Regards,

Lar



dbahooker@xxxxxxxxxxx wrote:
thanks but I dont have a problem getting business

for the most part, 2 people can run the same query at the same time--
unless you use some wierd persistent tables instead of using
tempTables.

Select *
INTO #SysObjects
From Sysobjects

this builds a temp table.. if you have 2 people that need to do the
same stuff at the same time; they will each have their own connection
so they can both fire this exact same statement

Select *
INTO #SysObjects
From Sysobjects




larpup wrote:
Response as follows:

dbahooker@xxxxxxxxxxx wrote:
why would you need unique views for a particular workstation?
I have never used SQL Server, but have started reading and studying it.

I work in Access and a legacy program which permits queries to the
local workstation.

more appropriately; you can do this for a particular user.

but it's all hogwash.

why would susies' view be different than toms?

I understand a vew is a "RETUN" of a query. So two or more workstations
can execute the same sql or store procedure at same time then? As I
said, am inexperienced with SQL Server.

seriously; in great detail > do you know how to program?
I am inexperienced to SQL Server and attempting to educate myself. If
you are so experienced , then it would behoove you to have a better
attitude. It could possibly you business, but that's another matter.

local queries, local tables-- they're completely unnecessary and all
they do is make your application too complex.

Not interested in local tables. Need to educate myself on the
differences between Access and SQL Server.


-Aaron


larpup wrote:
I've been asked to re-write an access app with sql backend.. can anyone
enlighten me regarding "how to emulate Access local queries"? Since
sql server is all on the backend, how does one make unique views for a
workstation?

Any advice is appreciated.

Lar

.

Relevant Pages

  • Re: Architecture Advice
    ... >> I'm going to be using SQL Server for a distributed ... >> application and I'd appreciate any advice on architecture. ... >> Simplest approach would be 2-tier client server and be done with it. ... it would be nice to be able to provide some data caching at the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: different environment fails to fill a dataset
    ... can't access the SQL Server and the Resources winform can access SQL Server ... They both work fine on my development workstation. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: What do I need to use Terminal Server?
    ... It's taken as offered and all good advice. ... I'm starting to see some major modifications to the overall network setup ... Then, based on what I found in #1, I would order the proper hardware ... and software for you - server, workstations, SQL Server if required, ...
    (microsoft.public.windowsxp.general)
  • Re: Error 823
    ... You've already gotten some advice, ... Tibor Karaszi, SQL Server MVP ... we've delivered the Raid System to a Recovery company. ... > I/O error detected during read at offset 0x0000001ef3c000 in ...
    (microsoft.public.sqlserver.setup)
  • Any idea why this wont loop?
    ... I am not a newbie to SQL Server but a newbie to creating DTS packages. ... I have a directory which will contain an undetermined number of Excel ... the first file, the transformation works great but then it doesn't loop ...
    (microsoft.public.sqlserver.dts)