Home » Renegade Discussions » Mod Forum » I need an education in SQL
| I need an education in SQL [message #444430] |
Mon, 28 February 2011 03:26  |
 |
reborn
Messages: 3231
Registered: September 2004
Location: uk - london
Karma:
|
General (3 Stars) |
|
|
I have a very limited understanding of databases and how to interact with them. At my place of work the Database Admins have servers running Microsoft SQL server 2005/2008.
I manage software that interacts with some of the databases on these servers which does so through an OBDC connection which I had to set up on the Application server.
However, I also sometimes view the tables on the databases using Microsoft sql server management studio 2005.
I'll log in using SQL server authentification rather than my windows credentials (as worryingly they actually let me have SA rights (well, the applications server needed SA to create the database, so I use that)).
Screenshot is a random google image
Then I'll browse to databases->the database I want->tables then I view the table...
I set up an ODBC connection on my client PC and sometimes view the databases in Microsoft Access instead, as I find setting up views easier that way.
This is the entire extent of my database knowledge. I do know how to run SQL queries, but I do not actually know any SQL queries.
What the fuck has any of this rambling got to do with renegade modding?
I want to know how to create a plugin that will interact with a database. I need to know how to install the database server, which database server software most people use, and I need to know how to create my tables, access data, modify data, write data, compare "cells", close the connection properly, pretty much everything.
Is there anyone willing to help?
What would be really fucking awesome would be a tutorial using the SSGM plugin.
The tutorial would ideally include how to install the DB software, then proceed to demonstrate in the plugn how to connect to the database and handle errors (like the db doesnt exist), how to create the table and set up the headings (if they do not exist) via the plugin itself. Then how to write some data and read some data, and modify some data too.
[Updated on: Mon, 28 February 2011 03:26] Report message to a moderator |
|
|
|
 |
|
I need an education in SQL
By: reborn on Mon, 28 February 2011 03:26 |
|
|
Re: I need an education in SQL
By: Spyder on Mon, 28 February 2011 05:31 |
|
|
Re: I need an education in SQL
|
|
|
Re: I need an education in SQL
By: reborn on Mon, 28 February 2011 05:45 |
|
|
Re: I need an education in SQL
By: Sir Kane on Mon, 28 February 2011 10:39 |
|
|
Re: I need an education in SQL
By: halo2pac on Mon, 28 February 2011 23:54 |
|
|
Re: I need an education in SQL
By: reborn on Tue, 01 March 2011 02:03 |
|
|
Re: I need an education in SQL
|
|
|
Re: I need an education in SQL
By: jnz on Tue, 01 March 2011 10:55 |
|
|
Re: I need an education in SQL
By: reborn on Tue, 01 March 2011 11:03 |
|
|
Re: I need an education in SQL
By: jnz on Tue, 01 March 2011 11:07 |
|
|
Re: I need an education in SQL
|
|
|
Re: I need an education in SQL
By: reborn on Tue, 01 March 2011 11:55 |
|
|
Re: I need an education in SQL
By: reborn on Tue, 01 March 2011 15:27 |
|
|
Re: I need an education in SQL
By: reborn on Wed, 02 March 2011 04:22 |
|
|
Re: I need an education in SQL
By: cAmpa on Wed, 02 March 2011 04:47 |
|
|
Re: I need an education in SQL
By: reborn on Wed, 02 March 2011 05:59 |
|
|
Re: I need an education in SQL
By: iRANian on Thu, 05 May 2011 14:06 |
|
|
Re: I need an education in SQL
By: reborn on Thu, 05 May 2011 15:03 |
|
|
Re: I need an education in SQL
By: bmruze on Mon, 09 May 2011 03:26 |
|
|
Re: I need an education in SQL
By: iRANian on Mon, 09 May 2011 16:49 |
Goto Forum:
Current Time: Wed Dec 18 09:39:27 MST 2024
Total time taken to generate the page: 0.00954 seconds
|
Search
Help
Members
Register
Login
Home
