Practice Test #4

Another pass!


I still missed a few, though.


The exhibit had Modified Date in the Before picture as normal datetime, and the After was a date... but not in the format that the Date type would expect, and by using CAST instead of CONVERT, it doesn't allow for an optional style.


I forgot what PARSE does, so I picked CONVERT. PARSE is for converting datetime or datetime2 datatypes between cultural formats.


Oh, I was irritated at this one! I hadn't learned when the results set gets sent from the cursor, and I peeked in the book, which unhelpfully said "To deallocate a cursor, use DEALLOCATE. When closing a cursor, use CLOSE." Thanks, book. That really clears it up. I went back and forth between the two, and clearly picked the wrong one. Oh well!

Maybe tomorrow I'll do even better.

Comments

Post a Comment

Popular posts from this blog

Board games and near the end of the gym challenge

Today was another success! Went to the gym after my two cups of coffee, warmed up the rest of the Picadillo for lunch, and finished a few chores. This evening, I was invited to a board game night with a few friends. We played Spinjas and Stuffed Fables. The gym was my last arm/chest routine day until the 31st, where I'll do the full body routine and see where I gained. I'm certain I didn't lose weight - way too many cookies and candies around to snack on, but hopefully I'm stronger. I certainly feel stronger and better, and that is enough to keep going. I'm looking forward to getting a better diet in January by not having sugar for the month, and continuing to go the the gym - just not daily. Stuffed Fables is a really cute game! We played Story 1 where a girl's blanket is stolen from a little girl's bed, and the Stuffed animals characters, Theadora, Stitch, Flops and Lumpy have to travel through the underworld to rescue the blanket and get back to bed b
Read more

December Challenge has ended!

Image
I'm really pleased! I met my December challenge and even blew past my wussy goal of 5 times or more a week. I went to the gym every day except for December 25th (they were closed) and December 26th (the weather was finally so nice that I opted to go for a walk instead). I even have check in proof! I even made appreciable gains in my workouts! December 1st workout sheet: December 31st workout sheet: I changed from doing a machine that simulated the situp movement with some weights to just the situp bench. Clearly I still have some work to do on my arms and shoulders, but that's not a big surprise. I'll just keep on keeping on! I took a picture on the first and today - not going to share those, but I did see a little positive change in my arm definition and my midsection. I also need to work on lowering my shoulder and changing my posture - I'm starting to lean forward. I'll keep taking pictures on the last days of the month to make sure there'
Read more

Surprising success with Ham and Bean soup

Image
I was nervous about making this bean soup because the Cajun version of HamBeens 15 Bean Soup mix was just not good, but I like ham and bean soup other times. I feel bad that I ended up throwing out the rest of the cajun version last year. This time, I stopped before tossing the regular seasoning packet in from my non-cajun HamBeens 15 bean mix, and smelled and tasted the seasoning in the packet. It was terrible! The "maltodextrin and other natural flavors" ingredients list I found about the packet seemed to be true. It was just overly sweet smoke flavor. I declined to use it. I later found a recipe for ham and bean soup in which the first few directions are "Open the bag of dried beans. If it contained a seasoning packet, throw that out." The soup was a huge experiment of what I've learned about seasoning, using the Instant Pot, the failure of the Cajun HamBeens 15 beans soup and reading through several ham and bean soup recipes. So, here is the final re
Read more