dnasca

exec (' SELECT DISTINCT ' 
  + @SearchField + ' FROM SchemaAudit WHERE StartDate >= ' 
  + Convert(varchar(20), @DateFrom) 
    + 'AND WHERE EndDate >= ' 
  + Convert(varchar(20),@DateTo) 
    + ' ORDER BY ' 
    + @SearchField 
    +' ASC')

dnasca

exec ('
     SELECT DISTINCT ' +
     @SearchField + ' FROM SchemaAudit WHERE StartDate >= "' 
                  + CAST(@DateFrom as varchar(20)) 
                  + '" AND EndDate >= "' 
                  + CAST(@DateTo as varchar(20)) 
                  + '"
                  ORDER BY ' + @SearchField +' ASC')

dnasca

# properties
$registerApp = new-object psobject -property @{
	name = $null
	path = $null
	type = $null
}

# constructor
function RegisterApp {
	param(

dnasca

$ApplicationClass = new-psclass Application {

	note -static objectCount 0
	method -static displayObjectCount {
		"$($this.ClassName) has $($this.ObjectCount) instances"
	}

	note -private Name 
	note -private Path 

dnasca

#goes in C:\Users\user.name\Documents\WindowsPowerShell (Microsoft.PowerShell_profile.ps1)

#prompt is automatically invoked
function prompt {
  # display the full, current path in the window title
  $host.ui.RawUI.WindowTitle = ( get-item -path ".\" -verbose ).FullName + "  ::  ${env:username}"
  
  # prompt: 14:22 :: c:\ > 
  write-host (($(get-date).ToString("HH:mm")) + " :: " + (get-location | get-item).Name) -nonewline -foregroundcolor yellow
  return " > "

dnasca

Beavis = { name: 'Beavis' };

Beavis.__proto = Human;

Human = {};

Human.__proto__ = Being

Being = {
	toString: function() { return this.name; }

dnasca

result = (function () {
  var result = 0;

  return {
    value: function() {
      return value;
    },
    
    increment: function() {
      return ++value;

dnasca

var createIdempotentWorker = function() {
  var isWorking = false;
  
  return {
    doWork: function() {
      if (isWorking) {
        console.log("I'm already working");
        return;
      }
      isWorking = true;

dnasca

// function with scope
functionWithScope = (function (){
  var x = 1;
  return function() {
    console.log('Private variable value: ' + x);
  };
}());

functionWithScope(); //output: 'Private variable value: 1'

dnasca

/* 
  the synchronous callback:
  
  create a function that can be called at a later time whenever the 
  higher order function (the function that were passing this function into -- aka: the function doing the calling)
  is ready to call/invoke this function. Read this a few times and it will eventually make sense :)  
*/
   whenDone = function () {
    console.log ("done")
   };