Truelogic Blog

Nested Cursors in T-SQL

nestedloop

We have two sample tablesĀ  : tracks – which store audio track info matches – table which stores tracks matched in external data As you can see in the table rows below, the Id field of the track table is the foreign key in the matches table in the form of trackId. The example T-SQL…

List of Sensors in an Android Phone

androidphone

A small utility to display the list of Sensors present in an Android phone. For those who are not interested in the code, the installable apk file is provided as a downloadable link at the end of this article. The Activity class package com.example.listsensors; import java.util.List; import android.os.Bundle; import android.hardware.Sensor; import android.hardware.SensorManager; import android.app.Activity; import…