Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Dustin B.
Senior Application Developer at CliftonLarsonAllen
Tutor Satisfaction Guarantee
SQL Programming
TutorMe
Question:

Using SQL, what is one way to detect case-sensitive changes between a historical and daily snapshot table (same schema)? Assume the following structure for both tables, and that we want to detect changes on FirstName and LastName: ID (PK) FirstName (cannot be null) LastName (cannot be null)

Dustin B.
Answer:

By using the HASHBYTES function, you can easily detect changes. Since we want to detect changes on FirstName and LastName, we need to combine the HASHBYTES function with the CONCAT function. Here is the snippet which would be a column in the query (or computed column in a table): HASHBYTES(‘SHA1’, CONCAT(FirstName, LastName)) By using the above, you simply compare. For simplicity, let’s just select the IDs from Table1 that differ from Table2. Also assume the above is a computed column called ChangingHash. SELECT A.ID FROM Table1 A INNER JOIN Table2 B ON A.ID = B.ID AND A.ChangingHash <> B.ChangingHash

jQuery Programming
TutorMe
Question:

Using jQuery, how would you select an element that contains BOTH classes A and B (hint: think intersection).

Dustin B.
Answer:

You can use a jQuery selector: $(‘.A.B’) Note: There must be NO space between A.B; having a space selects descendants of elements with class A that have class B. You can also select an element that contains EITHER class A or B (think union): $(‘.A, .B’)

C Sharp Programming
TutorMe
Question:

If you put the “this” keyword before a method argument, such as MyMethod(this string param1), what are you actually doing?

Dustin B.
Answer:

You are creating an extension method. For example, in the function given in the question, the function is extending the string type. In other words, it allows you to do things such as “Hello World”.MyMethod().

Send a message explaining your
needs and Dustin will reply soon.
Contact Dustin
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.