Code, Query, Ship, and Learn (Page 7)

Code, Query, Ship, and Learn

Sign in Subscribe

More issues

Budget Babe

Budget Babe is an ordinary lady striving to achieve financial freedom in Singapore before the age of 45. She is always looking for cost-effective ways to live a fulfilling life in amidst Singapore's rising costs, and writes in order to empower fellow Singaporeans on taking charge of

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(

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('

Jquery inputmask

/*! * jquery.inputmask.bundle.js * http://github.com/RobinHerbots/jquery.inputmask * Copyright (c) 2010 - 2016 Robin Herbots * Licensed under the MIT license (http://www.opensource.org/licenses/mit-license.php) * Version: 3.2.7

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

14 EXPERTS SHARE HOW TO DO WELL FINANCIALLY IN 2017

14 EXPERTS SHARE HOW TO DO WELL FINANCIALLY IN 2017 (FOR MALAYSIANS) Published January 5, 2017 by mr-stingy in Money http://www.mr-stingy.com/do-well-financially-2017-malaysians/

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

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.