jbnv

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

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

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

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

jbnv

-- This query generates another query which you will then run to get the maximum IDs.
SELECT STUFF((
	SELECT	'UNION SELECT '''+TABLE_SCHEMA+''' AS TABLE_SCHEMA,'''+TABLE_NAME+''' AS TABLE_NAME,'''+COLUMN_NAME+''' AS COLUMN_NAME,'
		+'CAST(MAX(['+COLUMN_NAME+']) AS VARCHAR) FROM ['+TABLE_SCHEMA+'].['+TABLE_NAME+'] AS [MaxPrimaryKeyValue] '
	FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
	WHERE OBJECTPROPERTY(OBJECT_ID(constraint_name), 'IsPrimaryKey') = 1 
	ORDER BY TABLE_SCHEMA,TABLE_NAME
	FOR XML PATH('')
),1,6,'') + 'ORDER BY TABLE_SCHEMA,TABLE_NAME'

jbnv

select n1000.n+n10.n*10+n1.n
from (select n=1900 union select 2000) n1000
cross join  dbo.Numbers n10
cross join  dbo.Numbers n1
--where n1000.n+n10.n*10+n1.n between 1900 and 2099

jbnv

Public Class Revertable(Of T)

    private _value as T
    private _oldValue as T
    private _hasChanged as Boolean = false

    public property Value as T
        get
            return _value
        end get

jbnv

Executive Summary

This is a snapshot of your business plan as a whole and touches on your company profile and goals.

Company Description

Provides information on what you do, what differentiates your business from others, and the markets your business serves.

Market Analysis

jbnv

var Thing = function() {
    console.log('Assemble this thing.');
}
 
// The decorators will also need to implement these functions to comply with Thing's interface.
Thing.prototype = {
    actionFunction: function() {
        console.log('actionFunction');
    },
    valueFunction: function() {