Calguns.net  

Home My iTrader Join the NRA Donate to CGSSA Sponsors CGN Google Search
CA Semiauto Ban(AW)ID Flowchart CA Handgun Ban ID Flowchart CA Shotgun Ban ID Flowchart
Go Back   Calguns.net > GENERAL DISCUSSION > Technology and Internet
Register FAQ Members List Calendar Mark Forums Read

Technology and Internet Emerging and current tech related issues. Internet, DRM, IP, and other technology related discussions.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2013, 9:16 AM
stilly stilly is offline
Banned
 
Join Date: Jul 2009
Location: Currently in a shanty I made in the river bottom by Eastvale.
Posts: 9,022
iTrader: 44 / 100%
Default Is there a QUICK start way to learn about MS SQL scripting?

I know what a query is, it is a search string that is entered to pull out data from a database file or several files.

The last queries that I ran were in MS access 2000...

NOw though I want to get into MS SQL but I see sites all over the place, is there one decent site that I can learn from or that is a great resource for noobs and advanced users alike?

My goal is to get to be a power user of sql in as fast as possible. having desk/book references is fine, and of those cool BIBLE books are fine too, I just gotta get up to speed and the more I can learn sooner the better.
Reply With Quote
  #2  
Old 04-13-2013, 9:20 AM
ocabj's Avatar
ocabj ocabj is offline
Calguns Addict
 
Join Date: Oct 2005
Location: Riverside
Posts: 7,118
iTrader: 39 / 100%
Default

I'd recommend learning MySQL or PostgreSQL since there's plenty of extensive (free) documentation out there, such as http://dev.mysql.com/doc/

Once you learn any SQL, you can pretty much apply it to other variations since syntax and semantics are very similar.

Plus, MySQL and PostgreSQL are fairly lightweight and easy to compile (or install via binaries) on your local system so you can just run the SQL daemon locally.
__________________

Distinguished Rifleman #1924
NRA Certified Instructor (Rifle and Metallic Cartridge Reloading) and RSO
https://www.ocabj.net | http://jocabphoto.com

My AR15 Service Rifle - Used for CMP/NRA High Power Service Rifle Competitions
My Eliseo R5 (Remington 700) Tube Gun - Used for NRA High Power (Match Category) Competitions
My M1 Garand Service Rifle - Used for JCG Matches, rebuilt by Dean's Gun Restorations
Reply With Quote
  #3  
Old 04-13-2013, 9:41 AM
stilly stilly is offline
Banned
 
Join Date: Jul 2009
Location: Currently in a shanty I made in the river bottom by Eastvale.
Posts: 9,022
iTrader: 44 / 100%
Default

Cool thanks.

I thought that most sql was the same, just like a little different under the hood prolly. Then I heard about MS and now Tsql... yeah whatever.

I will check out the link.
Reply With Quote
  #4  
Old 04-14-2013, 3:22 AM
ldivinag's Avatar
ldivinag ldivinag is offline
In Memoriam
 
Join Date: Oct 2005
Location: N37 33* W122 3*
Posts: 4,868
iTrader: 1 / 100%
Default

SQL is SQL.

it's when a vendor decides to add their own add-ons to it that screws people up.

for example, when i was working with an MS SQL box, there was no "LIMIT x,y" clause.

meaning, if i wanted the fiftieth row, but i only want 50-80, it would be something like

SELECT * FROM TABLE LIMIT 50, 30

well MSSQL doesnt have anything like it. MySQL did, which was my DBMS of choice since i was working with the AMP stack.


OP, what exactly, are you looking at? is it for a new job?
__________________
leo d.
Reply With Quote
  #5  
Old 04-15-2013, 9:17 AM
smird's Avatar
smird smird is offline
CGN/CGSSA Contributor
CGN Contributor
 
Join Date: May 2009
Location: Riverside
Posts: 7,146
iTrader: 39 / 100%
Default

I did one of those Sql in 24hours books, to get the basics. Then a ton of googling to get answers to specific things.

Also if you use SQL sever management studio, it's a lot like access.
Reply With Quote
  #6  
Old 04-15-2013, 9:04 PM
Corbin Dallas's Avatar
Corbin Dallas Corbin Dallas is offline
Veteran Member
 
Join Date: May 2006
Location: SD
Posts: 4,365
iTrader: 80 / 100%
Default

Sams teach yourself mysql in 24 hours or the 21 days version.

Then join stackoverflow.com to ask the pros.
Reply With Quote
  #7  
Old 04-15-2013, 10:02 PM
bigmike82 bigmike82 is offline
Bit Pusher
CGN Contributor
 
Join Date: Jan 2008
Location: W. Los Angeles
Posts: 3,052
iTrader: 59 / 100%
Default

Quote:
Originally Posted by ocabj View Post
I'd recommend learning MySQL or PostgreSQL since there's plenty of extensive (free) documentation out there, such as http://dev.mysql.com/doc/

Once you learn any SQL, you can pretty much apply it to other variations since syntax and semantics are very similar.

Plus, MySQL and PostgreSQL are fairly lightweight and easy to compile (or install via binaries) on your local system so you can just run the SQL daemon locally.
I gotta disagree with this.

SQL Server, unfortunately, is a completely different beast than MySQL or Postgres. Beyond the very basic 'select * from table' semantics, you're in a completely different environment. MySQL lends itself to nice, simple, easy to understand queries that actually make sense. SQL Server? ****, if you're not writing a dozen lines of SQL you're doing it wrong. It's totally bat**** crazy.

If your job is SQL Server oriented, get a TSQL and SQL Server book and read it. Don't start with MySQL, you'll only get confused and bitter at Microsoft.
__________________
-- 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
Reply With Quote
  #8  
Old 04-15-2013, 11:19 PM
stonith3901 stonith3901 is offline
Member
 
Join Date: Jul 2012
Posts: 164
iTrader: 3 / 100%
Default

Or get on the other bandwagon of noSQL.
Reply With Quote
  #9  
Old 04-27-2013, 9:58 PM
Charger Mark's Avatar
Charger Mark Charger Mark is offline
Member
 
Join Date: Dec 2008
Location: San Diego, CA
Posts: 248
iTrader: 79 / 100%
Default

If you know someone with a .edu email account, you can down load MS SQL Server 2012 or 2008 R2 from dreamspark.com. I'm going to play around with 2012 w/business intelligence to practice reporting once I finish applying to grad schools. Microsoft has a sample database called Adventureworks for educational purposes. There are lots of tutorials online for it. Check out YouTube and http://www.brentozar.com/sql-server-training-videos/ and http://msdn.microsoft.com/en-us/library/ms187731.aspx

Good luck!

Last edited by Charger Mark; 04-27-2013 at 10:45 PM..
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -8. The time now is 6:05 AM.




Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Proudly hosted by GeoVario the Premier 2A host.
Calguns.net, the 'Calguns' name and all associated variants and logos are ® Trademark and © Copyright 2002-2016, Calguns.net an Incorporated Company All Rights Reserved.