MRdNk

var sqlParams = [];

var forenameParam = {
    name: '@forename'
  , type: 'int'
  , value: 'Bob'
}

sqlParams.push(forenameParam);

MRdNk

{
  "name": "Demo",
  "version": "0.0.0",
  "description": "description",
  "main": "app.js",
  "directories": {
    "test": "test"
  },
  "dependencies": {
  },

MRdNk

In 'git bash'

mkdir behave && cd behave
git init
git pull https://github.com/jakiestfu/Behave.js.git master

Copy behave.js, into your local project.

MRdNk

C# List delegate

A delegate allows you perform an action on a list type, FindAll - returns a new list, based on the conditions you put into the delegate.

List<KeyValueBool<int, String>> list = disp.List.FindAll (delegate (KeyValueBool<int, string> kvb) {
  return kvb.Boolean == true;
});

MRdNk

DataTable

var DataTable = function (opts) {
  this.columns = [];
  for (key in opts) {
    if (opts.hasOwnProperty(key)) {
      // this.columns.push (opts[key]);
      this.columns.push (opts[key]);

MRdNk

Table event listener

var stmt = sql.query(conn_str, "SELECT * from tbl1");
stmt.on('table', function (table) {
  console.log('table', table);
})

MRdNk

An alternative to doing C# List Delegates (https://gist.github.com/4654896) is to use a Predicate / Lambda Expression...

private List<KeyValueBool<TKey, TValue>> _list;

public Boolean Exists (TKey ID) {
  return _list.Exists (item => EqualityComparer<TKey>.Default.Equals (item.Key, ID));
}

public TValue GetValue (TKey ID) {

MRdNk

ISNUMERIC(zipcode + '.0e0') --integer
ISNUMERIC(zipcode + 'e0')  --decimal

MRdNk

-- DATE ONLY ELEMENT
SELECT DATEADD(dd, 0,DATEDIFF(dd, 0, GETDATE()))

-- DATE TO NEAREST MINUTE
SELECT DATEADD(mi, DATEDIFF(mi, 0, GETDATE()),0)

-- CONVERT TO TIME as Varchar
SELECT CONVERT(VARCHAR(5), GETDATE(), 108)

MRdNk

GO
/****** Object:  UserDefinedFunction [dbo].[fnIsSameDate]    Script Date: 02/12/2013 17:02:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  	  Duncan Angus Wilkie
-- Create date: 12/02/2013
-- Description:	Do datetime (DATE only) match?