Posted by serge on 06/06/05 02:28

Queries would be either Views or Stored Procedures in your SQL database.
Normally Views are for select statement and the rest you would use Stored
Procedures.

When you open SQL Enterprise Manager you need to expand on the left
pane until you open your local server, databases and access your database.

SQL Query Analyzer is where you can execute SQL code for example
SELECT statements and see the result there.


> I'm moving things from Access to SQL Server. What do I do with queries?
I'm
> using Access 2000 to access Sql Server, and there doesn't seem to be
> anything for queries.
>
> Does SQL Server have queries, or are they just done in the page code (to
> access data on a website)?
>
> I also have a trial version of Enterprise Manager, but I can't figure out
> how to connect. If that would show queries.

• Next in forum: SSL Security Error
• Prev in forum: Re: Code in the database or middle tier (the CLR controversy)
• Thread view: Re: Another Newbie Question (about queries)

[Reply to this message]