Sunday, March 11, 2012

Another Newbie Question (about queries)

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.

Thanks

JAQueries 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.

No comments:

Post a Comment