jbnv

SELECT column_name
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE OBJECTPROPERTY(OBJECT_ID(constraint_name), 'IsPrimaryKey') = 1 
AND table_name = '<tableName>'

jbnv

SELECT OBJECT_NAME(object_id) AS [Name], 
    CASE 
    WHEN OBJECTPROPERTY(object_id, 'IsProcedure') = 1 THEN 'procedure'
    WHEN OBJECTPROPERTY(object_id, 'IsView') = 1 THEN 'view'
    WHEN OBJECTPROPERTY(object_id, 'IsTable') = 1 THEN 'table'
    WHEN OBJECTPROPERTY(object_id, 'IsScalarFunction') = 1 THEN 'function'
    WHEN OBJECTPROPERTY(object_id, 'IsTableFunction') = 1 THEN 'function'
    WHEN OBJECTPROPERTY(object_id, 'IsTrigger') = 1 THEN 'trigger'
    ELSE 'other'
    END AS [Type]

jbnv

DECLARE @Object AS INT;
DECLARE @ResponseText AS VARCHAR(8000);
 
EXEC sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
EXEC sp_OAMethod @Object, 'open', NULL, 'get',
'http://www.webservicex.com/stockquote.asmx/GetQuote?symbol=MSFT', --Your Web Service Url (invoked)
'false'
EXEC sp_OAMethod @Object, 'send'
EXEC sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
 

jbnv

DECLARE @tblName sysname
DECLARE @tblId INT
DECLARE @sql VARCHAR(MAX)

DECLARE cTable CURSOR FOR 
    SELECT [sql]
OPEN cTable
FETCH NEXT FROM cTable
INTO @sql

jbnv

jbnv

jbnv

camelize = function (str) {
	return str.replace(/[\-_](\w)/g, function (match) {
		return match.charAt(1).toUpperCase();
	});
};

jbnv

define(['durandal/app', 'durandal/system', 'knockout'], function (app, system, ko) {
 
    var data = ko.observableArray();
 
    return {
        data: data,
        // Page events
        activate: function () {
            system.log('Lifecycle:activate');
        },

jbnv

Option Explicit On

Imports System
Imports System.Text
Imports System.Text.RegularExpressions
Imports System.Net
Imports System.Xml
Imports System.IO

Namespace Collecta

jbnv

composition.addBindingHandler('console', {
  update: function (element, valueAccessor, allBindings) {
    data = ko.toJS(valueAccessor() || allBindings());
    console.log(data);
  }
});