About Programming: Count SQL Rows, Escaped Names

If you can't see this email, click here

Programming From Angela Bradley, your About Programming Editor Dear Subscriber, Welcome to this week's edition of your About Programming Newsletter. This week we look at how to count SQL result rows. Next we look at escaped names, reference methods in Ruby, and GOTO. Have a great week! Counting SQL Result Rows SQL provides the COUNT function to retrieve the number of records in a table that meet given criteria. We can use the COUNT(*) syntax alone to retrieve the number of rows in a table. Alternatively, a WHERE clause can be included to restrict the counting to specific records. Escaped Names Here's a little tip that might trip up people who are not completely familiar with VB.NET: The use of square brackets to identify escaped names. References to Methods in Ruby Trick question: How do you take a reference to a method in Ruby? It's a trick question because a method cannot exist on its on in Ruby. Ruby doesn't have "function pointers." You might guess that you can simply store the object and a symbol with the method name, and you'd be right. Or a proc object that calls the method on the object, and again you'd be right. GOTO Statement to be Included in JDK8? Joe Darcy announced yesterday a late-breaking language change for JDK8 - the inclusion of a goto statement. He cited "increased expressiveness" and "more compact code" as inherent motivations behind the change. Programming Ads SQL Programming SQL Server Database SQL SQL Server News Letters Featured Articles Remove Auto Generated "&" in Delphi's Menu Item Caption Improving Collision Detection in Asteroids Challenge Question #003   More from About.com Financial Emergencies An unexpected change in your financial situation can be incredibly stressful. Here's how to cope. More> Retirement Planning Learn the top five things you need to do in order to start building a retirement nest egg. More>   Sign up for more free newsletters on your favorite topics You are receiving this newsletter because you subscribed to the About Programming newsletter. If you wish to change your email address or unsubscribe, please click here. About respects your privacy: Our Privacy Policy Contact Information: 249 West 17th Street New York, NY, 10011 © 2012 About.com   SQL Books SQL in a Nutshell: A Desktop Quick Reference Teach Yourself SQL in 10 Minutes SQL: The Complete Reference, Second Edition Advertisement