While we are on the topic, "seek" and "lookup" seem like the same thing, at least in terms of their syntax and what they're trying to accomplish. I'm assuming with...

Oh wow thanks for those links.

Thank you for both answers. I'll work on it.

bump

This may be a stupid question but everytime I make a new command or query with T-SQL, do I have to open up a new query window or can I...

Oh I know don't mistake my impatience for arrogance or whatever. You guys are amazing helpers. I just was getting really frustrated. And it worked so you've done me a...

anyone?

Just tried it again.

Msg 5105, Level 16, State 2, Line 1

A file activation error occurred. The physical file name ' C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\APRESSFINANCIAL.mdf' may be incorrect. Diagnose and correct...

Ah ok I thought it would be best to start practicing with full recovery as in a production environment but I get your point starting out.

wow. I'm an idiot. Thank you so much

I appreciate that very informative post, especially the certification part.

Great post and I totally agree with you larry. The point of the certification was JUST to get the first job and as fast as possible (I'd like a home...

Thanks for that. I have the exam stuff, but this caught my eye.

http://www.amazon.com/Beginning-Microsoft-Server-2012-Programming/dp/1118102282/ref=sr_1_4?s=books&ie=UTF8&qid=1364410337&sr=1-4&keywords=sql+server+2012+beginners

Also guys, if anybody has suggestions for books to start with for SQL 2012 I will get them asap. Preferably ones that allow lots of interaction and exercises.

Yea, I have a gaming monster that I am planning to use to run multiple virtual machines. As far as entry level/internship jobs, I've searched for months here in south...