|
Posted by JA on 11/26/07 00:42
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!
[Back to original message]
|