SQL query

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

OK, i'm wanting to pull some data out of the SQL database here at certforums. First thing does anyone have any knowledge of SQL and how to query a database. I have phpMyadmin to interface with the database but dont really know how to start writing my queries.

SiFir

 

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

I don't use php at all (ASP & ASP.NET) so can't help you there. However SQL Server is ANSI SQL 92 compliant and also supports Transact SQL (T-SQL). If you run into a specific question and/or need help with a specific query, just holler. To get a general overview of querying a DB, take a look at these:
http://www.geocities.com/SiliconValley/Vista/2207/sql1.html
http://www.baycongroup.com/tocsql.htm
http://www.firstsql.com/tutor.htm

 

Thanks for the info Larry, I'll take a look. BTW, welcome to CertForums. Hope to see you around again.

SimonV

 

Hey, Larry - watch yourself - that guy's running this place