Code, Query, Ship, and Learn

Sign in Subscribe

Topic

IT Programming

A collection of 46 issues

Jquery Mobile Select2 with asp.net web service asmx

$("#ddlCust").select2({ minimumInputLength: 2, // minimumInputLength for sending ajax request to server width: 'resolve', // to adjust proper width of select2 wrapped elements ajax: { url: "../DataServices/ws_Master.asmx/GetAutoCompleteCustomerList", // Webservice - WCSelect2 and WebMethod -AccessRemoteData type: "Post", dataType: 'json', params: { contentType:

autoNumeric.js.

autoNumeric 1.9.41 is a jQuery plugin that automatically formats currency and numbers as you type on form inputs. It supports most International numeric formats and currency signs including those used in Europe, North and South America, Asia and India lakhs. $(".testInput").autoNumeric('init', { aSep:

THE CAUSE OF EVERY DEADLOCK IN SQL SERVER

THE CAUSE OF EVERY DEADLOCK IN SQL SERVER Posted by sqlrockstar Employee in Geek Speak on 19-Jun-2016 01:06:00 https://thwack.solarwinds.com/community/solarwinds-community/geek-speak/blog/2016/06/18/the-cause-of-every-deadlock-in-sql-server#start=25

Compare two databases for objects differences

https://gallery.technet.microsoft.com/scriptcenter/Compare-two-databases-for-b44e7afa CREATE PROC sp_CompareDb( @SourceDB SYSNAME, @TargetDb SYSNAME ) AS /* DECLARE @SourceDB SYSNAME='DB1', @TargetDb SYSNAME='DB2' */ SET nocount ON SET ansi_warnings ON SET ansi_nulls ON DECLARE @sqlStr VARCHAR(8000) SET @SourceDB= Rtrim(Ltrim(@SourceDB)) IF DB_ID(

select all and remove all with chosen js

$("select").on("chosen:showing_dropdown", function(evnt, params) { var chosen = params.chosen, $dropdown = $(chosen.dropdown), $field = $(chosen.form_field); if( !chosen.__customButtonsInitilized ) { chosen.__customButtonsInitilized = true; var contained = function( el ) { var container = document.createElement("div"); container.appendChild(el); return container; } var width = $dropdown.width(); var

Generating Tables from SQL expressions

SELECT CONVERT(NVARCHAR(MAX), (SELECT (SELECT 'Top Thirty Sales per City (' +CONVERT(CHAR(11),GETDATE(),113) +')' FOR XML PATH(''), TYPE) AS 'caption', (SELECT 'rank' AS th, 'Sales' AS th, 'City' AS th FOR XML RAW('

Webcam library for capturing JPEG/PNG images in JavaScript

// WebcamJS v1.0.23 // Webcam library for capturing JPEG/PNG images in JavaScript // Attempts getUserMedia, falls back to Flash // Author: Joseph Huckaby: http://github.com/jhuckaby // Based on JPEGCam: http://code.google.com/p/jpegcam/ // Copyright (c) 2012 - 2017 Joseph Huckaby // Licensed under the MIT License

USEFULL DMV MS SQL 2016

SELECT TOP(10) dows.* FROM sys.dm_os_wait_stats as dows ORDER BY dows.wait_time_ms DESC --CPU BOUND QUERY SELECT TOP 5 st.text, qp.query_plan, qs.* FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) st CROSS

Stored procedure working when run manually, not running in SQL Agent Job XML sp_OACreate

1 down vote accepted I had this same issue when google geocoding and parsing the XML result. Seems that when run via an SQL job the XML result was being truncated. Found the solution here: http://www.progtown.com/topic376715-a-problem-with-spoagetproperty-p2.html Had to put: SET TEXTSIZE 2147483647; at the start

Detect hashchange and hash existed code run duplicate?

https://stackoverflow.com/questions/33056521/detect-hashchange-and-hash-existed-code-run-duplicate var hash = ''; $(document).load(function() { $(window).trigger('hashchange'); }); $(window).on('hashchange', function() { if (hash == window.location.hash) { // do nothing, hash is the same as it was previously return; } hash = window.location.hash; if (hash) { alert("Apple"