Re: Is sql server as good as access 97?

From: Michael Culley (mculley_at_NOSPAMoptushome.com.au)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 10:32:29 +1000

"a" <a@a> wrote in message news:#uWCgCCpEHA.1152@TK2MSFTNGP11.phx.gbl...
> You will want to look at creating stored procedures to reaplce the
> parameterized queries you used in access97.

Hi Jason,

Thanks for the reply, I was locked into converting the query to a view and
didn't think of stored procs. Unfortunately the database I am converting
uses queries stacked up to 10 levels deep with parameters at any of one or
more of those levels. AFAIK, the stored proc will only work if the
parameters are at the very top level query because you can't use a stored
proc in a select statement.

> Also, I'd recommend getting used to using the Query Analyzer to interface
> with your SQL databases over Enterprise Manager. It may eat up a bit of
> time now learning to write straight T-sql but you'll save significant long
> term time.

I've written all of the T-sql for the database as well so that the app can
create the database. Besides being for learning purposes is there any other
reason to use Query Analyzer? Wouldn't it get cumbersome, say, if you wanted
to do a quick check of the relationships in the database? 

--
Michael Culley

Relevant Pages

  • Re: Help me convince the dev manager. Please.
    ... The query cost w/ dynamic SQL won't necessarily be lower. ... Some might complain about the maintaining multiple stored procs, ... > is no database design or structure that would help with this problem. ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored procedures vs. command strings in c#...
    ... > general consensus that the best practices is to use stored procs. ... query is executed, it's cached execution plan is used, it's not recompiled. ... > within the database server. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Does anyone know any available tool used for viewing the impact on database and stored procs fro
    ... If you are just looking for the list of stored procs you would need to revise you can use the following query in the database you are modifying: ...
    (microsoft.public.sqlserver.tools)
  • Re: Limiting T-SQL code as a .NET development standard
    ... Stored Procedures, Views, function. ... do not build code in the database. ... It's false to say that using parameterized queries is not as ... What is it "to implement DAL as stored procs"? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
Loading