Month: December 2017

IonicCourseCode1

declare var $:any;




function onClickButton(){

        let url = 'http://transportapi.com/v3/uk/train/station/exc/live.json?'

            +'app_id=*****&'

            +'app_key=******************';
//get your own app_id and app_key from http://transportapi.com/v3/uk

        $.get(url).then(

            (data:any)=>{

                var x = data;

                let element = document.getElementById("statusText");

                if(element != null){

                    element.innerHTML = '<ul>';

    

                    for(var i=0;i<data.departures.all.length;++i){

                        let itm = data.departures.all[i];

                        let itmString = '<li>Plat ' + itm.platform

                            + ' Time ' + itm.expected_departure_time

                            + ' To ' + itm.destination_name + '</li>';

                        element.innerHTML += itmString;

                    }

                    element.innerHTML += '<ul>';

                }

                

            }

        );  

}

//(see c:\users\IonicNinja\Documents\TestTrainTimetable\index.ts)

sp_who you can filter

SELECT spid,
 sp.[status],
 loginame [Login],
 hostname, 
 blocked BlkBy,
 sd.name DBName, 
 cmd Command,
 cpu CPUTime,
 physical_io DiskIO,
 last_batch LastBatch,
 [program_name] ProgramName 
FROM master.dbo.sysprocesses sp 
JOIN master.dbo.sysdatabases sd ON sp.dbid = sd.dbid
where hostname='BOARDROOM'
ORDER BY spid