|
Comments
|
|
Good examples and the video clarity was fine.
|
|
|
Very good! Wish I would have had that a few weeks ago! :)
|
|
|
That was a perfect example. One question though. Is this true in a store procedure as well?
|
|
|
Is this true in a stored procedure as well?
Thanks,
Leonard Peoples
peoplesl@co.kern.ca.us
|
|
|
Good stuff and very informative.
|
|
|
Along the lines for the separate if statements. Does SQL offer an else if or as Select case statement.
Good job showing the pitfalls, I am beginning to use conditional logic in stored procedures - your video helps!
|
|
|
Nice job!
|
|
|
Very precise and easy to understand. I would suggest a good description of the Begin/End would be that they provide the scope of the if clause. Similar to programming practice (ie - in VB you would have If()Then...End; in C# you would have If(){}). Then/End sets scope for VB and the curly brackets {} set the scope for C#. Hope that helps and thanks for the video. Very nicely done!!!!
|
|
John H Davis on
9/29/2010
Not quite as good quality as usual.
|
|
Joe Tigeleiro on
9/29/2010
good explanation of the pitfalls that can occur
|
|
|
Great - I had struggled with this to the point of enraged frustration. I still struggle with nested IF statements. I seem to be able to make them work, but BOY is it ugly.
Would love to see a video on it and see if I'm just plain doing it wrong.
If x = 1
Begin
if y = 3
begin
if z > 0 etc...
Really? Is that just what happens when you mix procedural and non-procedural code?
|
|
|
Excellent presentation.
|
|
|
Great tip for a beginner. Who would have known?
|
|
|
Great job!
|
|
|
Very helpful.... one of the best blogs on sql server. Thanks so much for sharing.
Cheers - DV
|
|
|
Great, I like it.
|
|
|
too simple
|
|
|
I would use a different example but you did a great job in describing what happens when you don't format it properly. Your voice is amazing - clear and crisp with music in it. Nice and memorable - you need to do more videos.
|
|
|
I needed this two days ago. I discovered the answer through a forum online, but this video helped me understand a bit better. Thanks!
|
|
Steve Harris on
9/29/2010
Very basic but clear and informative.
|
|
|
Better use of my time than most of today!
|
|
Bruce Wendler on
9/29/2010
This was great. I never could figure out why my IF / ELSE didn't work, so I always used CASE statements.
|
|
|
You have a very pleasant voice and a good way of explaining things, but at the point where your execution pulled back two results, you really should have explained why, or started over. Given that this tutorial is targeted at the inexperienced, they could easily be confused.
|
|
|
good topic. Have made errors with if/else a few times.
|
|
|
Never underestimate a good explanation of the basics. Nice demo
|
|
Nancy Simmons on
9/30/2010
One more time, a short video with a great explanation!
|
|
|
It's all in the syntax!
|
|
|
thanks so much for your knowledge on this topic, as i was only trying to do what you have demonstrated a few days ago and I kept getting to many weird things. So I changed my ode to use the GOTO functions
|
|
|
Thanks Andy, as tsql newb this was helpful.
|
|
|
You are good. Congratulations
|
|
Terry MacLean on
9/30/2010
Thank you - I've been working with TSql for years and this still gets me
|
|
|
Excellent as always Andy
|
|
|
hi, you did it perfectly, if/else with and without begin/end blocks; its impacts; explained clearly; well done.
|
|
|
very good fro basic
|
|
|
video good, extra content in email GREAT!!!
|
|
|
Thanks, i have had that exact problem before and couldnt figure out why my if condition was not executing correctly
|
|
|
Excellent information. I always enjoy your videos and information. This one, while very simple in message, filled a hole I didn't know I had in my knowledge.
Thanks a ton for all you do for the SQL community!
|
|
|
I have been in the SQL business for a while and this webcast is one of the Best uses of my time. Thank you Andy for doing this!
|
|
|
good stuff!
|
|
Trevor Lewis on
10/5/2010
I would never have guessed that you would need the begin and end for the if else statements. I guess you need those like brackets in other languages. Excellent video.
|
|
|
good selection of basic functionality that can be confusing
|
|
|
Useful video
|
|
ML Stephens on
10/25/2010
just what I wanted
|
|
|
This should have a warning that it purely for beginners. The subject matter here is too simple to be useful.
|
|
|
Great videos. I am old to programming but new to sql.
|
|
Al Martinez on
10/29/2010
You did great.
|
|
Steve Culshaw on
11/4/2010
Good overview.
I tend to think of it as ... its going to run one statement after the IF and the begin/end makes a single composite statement
For me, you zoomed in to far in some sections, so the code lines were trimmed
|
|
|
Excellent job Andy, as always!
|
|
|
you did fine.
|
|
|
cool..great job
|
|
|
A bit different from PL/SQL--good to know.
|
|
Don Nesbitt on
11/24/2010
You explained it well; the design of the coding seems wrong and counter-intuitive.
|
|
|
Truly amazing. Thank you very much.
|
|
|
You did great! I needed this just yesterday so this video is quite timely and you did a great job of explaining the functionality.
thanks!
|
|
|
Clear and Concise
|
|
Stephen Morgan on
12/27/2010
Good job. I'm looking to review SQL basics as I have not been able to code much over the past year or two. Thanks!
|