SQL question

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
Hi

I have never used an sequel server application although I have medium knwldege of the language. What application is it that you use to manipulate sql statements? I wanting to download a trial version from somewere???
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
bsnapool,
That's a pretty broad question. There are many applications that you can manipulate SQL with. SQL server comes with it's own query tool available on the server itself. You can run SQL via access queries, or download a 3rd party tool that executes SQL using DSN and DSN'less connections. If you are really interested in SQL then using VB or VBA to execute SQL statements might be the way to go. I use a product called Schema Plus which works well for me. Do google search if you are interested in this product.

HTH
Cal
 

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
Cal

Thanks for your reply.. I'll try dowloading and let u know how i get on.

Andrew
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi Andrew

To be honest, if you have Access/MSQuery on your computer then you already have a good starting point where you can build up simple (and not so simple) SQL statements and then examine the code produced.

Richard
 

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452

ADVERTISEMENT

Does anyone work within the SQL environment? I ask this as I am wanting a job within SQL... and was wondering what it was like writing SQL quries??
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,930
Office Version
  1. 365
Platform
  1. Windows
Andrew

SQL is a broad subject, and could mean different things

Are you actually talking about Microsoft SQL Server?

Or do you mean Structured Query Language in general?
 

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452

ADVERTISEMENT

Are you actually talking about Microsoft SQL Server?

Yes,

sorry for being vague, but Im looking for information on the whole subject.. Im understand that SQL language is written within SQL server?
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
SQL (the language) is a standard language that many relational databases use to manipulate the data in the tables/queries. SQL Server uses one variant of SQL, Oracle another, MySQL a third etc etc. SQL scripts/queries written for SQL Server will not be immediately portable to another database flavour (unless it's a really simple script) as each database will have its own unique functions, that may not exist on any other Db. There is an awful lot of commonality between the various types of SQL though, so a good grounding in one flavour will likely mean you can adapt very easily to another (it's almost akin to different accents in human languages eg Americans speak English, and for the most part I can understand everything they say, but there may be one or two words where I have to ask them what the word means).

Make sense?

Richard
 

PolarBear

Board Regular
Joined
Sep 26, 2005
Messages
215
I work in an AS-400 environment using Excel, VB, Access, and SQL. SQL is very fast, and allows you to search huge amounts of data (data you couldn't work with in Excel, as you go beyond the 65,000 row limit). I've only had limited SQL training (I've picked up a lot on the Internet), so most of my queries are pretty basic. They can get really complex.

It really helps to understand relational databases if you want to use SQL effectively. Again, you can find lots of primers on RD's on the net. Simple SQL statements searching one datafile are pretty easy; when you start doing multiple joins to other files, things can get complex.

Still, I get quite a kick when my users come to me for help with a problem, and I can write a (or modify an existing) query in a matter of minutes, and have a solution for them before they leave my desk.

If you visit the "Sourceforge" section of the Slashdot website (slashdot.org), you can find some open source SQL editors, etc. that may let you play around with SQL. I think you still need to install a SQL database to get true functionality. MS offers a developer version for $50 US, and an "Express" version for free, but I don't know how much functionality they offer.
 

bsnapool

Active Member
Joined
Jul 10, 2006
Messages
452
Loud and clear, Thanks for all your help Richard, I know It must be like second nature to your self, but I am wanting to get to grips with the basics..

How long do you think it should take to pick... Advanced ones with Joins etc etc?

Any more information with regards to SQL server would be great...
 

Watch MrExcel Video

Forum statistics

Threads
1,114,398
Messages
5,547,729
Members
410,810
Latest member
lilwayne
Top