Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Grayco
Starting Member
22 Posts |
 Posted - 2010-04-08 : 15:32:11
|
| Greetings Everyone,At work we have a huge database full of quantitative date.We use MS SQL server 7.0I work 12 hour days, three or four days per week. I'm currently on one of my four day off weekends.I would like the ability to try out solutions (at home) that are generously supplied in this forum.I've never created a SQL database but I'de like to try.I have found free MS SQL server 2005 Express software.Is this an appropriate software for what I want to do?Is there a beginners guide to creating a SQL database?Your thoughts are appreciatedThanksGlen Ray |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-04-08 : 16:20:20
|
| You can answer most of your questions by reading the SQL Server documentation:SQL Server 2005 Books Online (November 2008)Designing and Creating Databaseshttp://msdn.microsoft.com/en-us/library/ms191425(v=SQL.90).aspxSQL Server 2005 Books Online (November 2008)CREATE DATABASE (Transact-SQL)http://msdn.microsoft.com/en-US/library/ms176061(v=SQL.90).aspxCODO ERGO SUM |
 |
|
|
Grayco
Starting Member
22 Posts |
Posted - 2010-04-10 : 12:19:59
|
This is great information. ThanksI think this may be a bit more than I need right now. I just need a way to test some of the SQL code that the experts on this forum are providing.I access the data through Excel by importing external data into MS Query.I just created a table in MS Access. I find I can access it just like I access the database at work.Do you know if the SQL is the same as MS SQL server 7.0?Thanks for your inputsGlenquote:
Originally posted by Michael Valentine Jones
You can answer most of your questions by reading the SQL Server documentation:SQL Server 2005 Books Online (November 2008)Designing and Creating Databaseshttp://msdn.microsoft.com/en-us/library/ms191425(v=SQL.90).aspxSQL Server 2005 Books Online (November 2008)CREATE DATABASE (Transact-SQL)http://msdn.microsoft.com/en-US/library/ms176061(v=SQL.90).aspxCODO ERGO SUM
|
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-10 : 14:48:05
|
| If you have SQL Server 7.0 at work, then that's what you should test any solutions on. Would it be possible to get remote access from home to a testing environment at work? That might be a better solution.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
Grayco
Starting Member
22 Posts |
Posted - 2010-04-10 : 18:19:38
|
Unfortunately the system is an isolated system that has no external access. Not even to the main company network.quote:
Originally posted by DBA in the making
If you have SQL Server 7.0 at work, then that's what you should test any solutions on. Would it be possible to get remote access from home to a testing environment at work? That might be a better solution.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee.
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-04-10 : 18:51:27
|
| Access and SQL 7 are different beasts. Some syntax will be the same, but a lot of it won't be.SQL Server 7.0 is ancient at this point. It hasn't even been supported by Microsoft in years. I haven't touched SQL Server 7.0 in about 10 years. I wouldn't suggest learning it unless your system is going to be around for a long time, and you plan on staying there. You should consider learning SQL Server 2008 instead.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
Grayco
Starting Member
22 Posts |
Posted - 2010-04-10 : 23:04:45
|
I will probably be there for quite a while. As far as SQL 7 goes the company is just now starting to migrate away from Lotus Notes for email. About 15 years ago someone created some maintenance applications in Access. We're still using them. My guess is SQL 7 will be there longer than me.quote:
Originally posted by tkizer
Access and SQL 7 are different beats. Some syntax will be the same, but a lot of it won't be.SQL Server 7.0 is ancient at this point. It hasn't even been supported by Microsoft in years. I haven't touched SQL Server 7.0 in about 10 years. I wouldn't suggest learning it unless your system is going to be around for a long time, and you plan on staying there. You should consider learning SQL Server 2008 instead.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
|
|
|
|
|
|
I need a test database at home