-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
SQL script
- Thread starter Chas17
- Start date
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
That's a SQL Server script alright, methinks.
Here's a link for SQL Server Express Management Studio (SSMSE) at MSDN ... it at least gives you an environment to view and administer a database (which also, btw, needs to be created before the tables are created). It's not a typical way for end users to interact with the data, but you can work directly with your data via SQL in management studio.
Here's a link for SQL Server Express Management Studio (SSMSE) at MSDN ... it at least gives you an environment to view and administer a database (which also, btw, needs to be created before the tables are created). It's not a typical way for end users to interact with the data, but you can work directly with your data via SQL in management studio.
Upvote
0
Excel Facts
Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Thanks.
I thought I had downloaded all that already, clearly Microsoft has me confused and I must admit I do not know what I am doing with this. Color me stupid but Microsoft websites drive me batty.
Thanks for help but I am going to have to stop and do some reading, or get a MAC...
Chas
I thought I had downloaded all that already, clearly Microsoft has me confused and I must admit I do not know what I am doing with this. Color me stupid but Microsoft websites drive me batty.
Thanks for help but I am going to have to stop and do some reading, or get a MAC...
Chas
Upvote
0
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
I still get confused with the MSDN pages myself.
If you search at Amazon for SQL Server Express books, you'll find a number of books that get you started. Probably they have the same software on CD behind the back cover - more importantly, should be a general introduction to SQL Server.
Overall, you can make a distinction between SQL (a language used for interaction with relational databases), and an RDBMS, or relational database management system. SQL Server, Oracle, IBM, and so forth all provide tools for creating and managing databases - this is the part that tends to be a little different in each system, and also can be quite complex as it comprises everything related to storage management, users, network services, backup and restore, and so on, as well as enhancements to SQL for programming databases.
In other words, you need to know SQL (a basic tool for working with your data). And you need to know a little about the database system you are working with - in this case, SQL Server. The express editions are often much like the full-blown enterprise editions, but generally are limited to a smaller size (maybe 2-4 gigabytes). Nevertheless, they do get you up to speed pretty well though, and SQL Server Express is used by a beginners to pros alike.
Hope this helps,
Alex
If you search at Amazon for SQL Server Express books, you'll find a number of books that get you started. Probably they have the same software on CD behind the back cover - more importantly, should be a general introduction to SQL Server.
Overall, you can make a distinction between SQL (a language used for interaction with relational databases), and an RDBMS, or relational database management system. SQL Server, Oracle, IBM, and so forth all provide tools for creating and managing databases - this is the part that tends to be a little different in each system, and also can be quite complex as it comprises everything related to storage management, users, network services, backup and restore, and so on, as well as enhancements to SQL for programming databases.
In other words, you need to know SQL (a basic tool for working with your data). And you need to know a little about the database system you are working with - in this case, SQL Server. The express editions are often much like the full-blown enterprise editions, but generally are limited to a smaller size (maybe 2-4 gigabytes). Nevertheless, they do get you up to speed pretty well though, and SQL Server Express is used by a beginners to pros alike.
Hope this helps,
Alex
Upvote
0
Similar threads
- Solved
- Question
- Question
