469,356 Members | 2,322 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,356 developers. It's quick & easy.

How to work in SLQ Server 2005

JA
I am moving my site to a host that has SQL Server 2005. I am pretty good
with Access, but I don't know much about SQL Server.

I'm currently using SQL Server 2000, and I access it with Access 2000, which
means I can't do a lot.

Would I be able to work in it using SAL Server Express? What I am
particularly interested in, is being able to run queries (views).

I need to update stock every day. If I was using Access I would import or
link the new stock table, and then join the 2 tables by the product number -
(the product table and the new stock table), and pull the records where the
stock amounts were different, then copy the column from the stock table to
the product table (or do an update query, although copying is usually
quicker and easier).

I would do that, not just for stock amounts, but for price changes, to add
descriptions, and a few other things.

How can I do that in SQL Server 2005? What program do I need to have on my
desktop to do that?

Please explain in baby terms, if possible!

Thanks!
Nov 26 '07 #1
1 1462
On Nov 25, 6:42 pm, "JA" <jarmour at kc.rr.comwrote:
I am moving my site to a host that has SQL Server 2005. I am pretty good
with Access, but I don't know much about SQL Server.

I'm currently using SQL Server 2000, and I access it with Access 2000, which
means I can't do a lot.

Would I be able to work in it using SAL Server Express? What I am
particularly interested in, is being able to run queries (views).

I need to update stock every day. If I was using Access I would import or
link the new stock table, and then join the 2 tables by the product number -
(the product table and the new stock table), and pull the records where the
stock amounts were different, then copy the column from the stock table to
the product table (or do an update query, although copying is usually
quicker and easier).

I would do that, not just for stock amounts, but for price changes, to add
descriptions, and a few other things.

How can I do that in SQL Server 2005? What program do I need to have on my
desktop to do that?

Please explain in baby terms, if possible!

Thanks!
If your question is more on SQL server express I can help slightly.
SQL Server express does not have import/export capabilities. But you
can backup and restore databases. I do not know what restrictions your
ISP or web server are, but if you could backup from your copy and do a
restore on the web server that could work. Although, if you want to do
this often you would want to automate this.

HTH
Nov 26 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by ABC | last post: by
17 posts views Thread by Danieltbt05 | last post: by
17 posts views Thread by Rob R. Ainscough | last post: by
5 posts views Thread by MichiMichi | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.