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

Code, Query, Ship, and Learn

Sign in Subscribe

More issues

Kill All Active Connections To A Database

To kill all the connections to your database you can use the ALTER DATABASE command. Sometimes you want to restore the database from a backup but can't because people are connected. Here is one way which will kick off all the users immediately TSQLLINE NUMBER OFF | HIDE | SELECT

High Dividend Stocks

High Dividend Stocks The stock counters listed in KLSE/ Bursa Malaysia market which have dividend yield higher than 3% in the last Trailing Twelve Month (TTM) and in last financial year are shown in this page. http://klsestockpick.com/high-dividend-stocks/

Crowdo (Referral Unique Code: ECF003282)

Why should I invest? There are a number of reasons you may want to invest in an Offer: 1) To diversify your investment portfolio; 2) To make a return on your investment; 3) To help a friend launch their business; 4) To help small Malaysia businesses. Investors should implement a

Table To JSON and back to Table TSQL MSSQL

TSQL CREATE TABLE #TBL_ADM_USER ( user_id INT, user_name NVARCHAR(1000) ) INSERT INTO #TBL_ADM_USER VALUES (1,'NAME1') INSERT INTO #TBL_ADM_USER VALUES (2,'NAME2') INSERT INTO #TBL_ADM_USER VALUES (3,'NAME3') DECLARE @XML_STR AS NVARCHAR(MAX) SET

TSQL to rename and script new modified stored procedure

SELECT 'EXEC SP_RENAME ''' + name + ''' , ''' + 'X_20170223_' + name + '''' FROM sys.objects WHERE type = 'P' and modify_date > '2016-09-09 16:37:38.913' and name not like 'X_%'

SQL 2014 dont have data tools

Download SQL Server Data Tools (SSDT) What happened to SQL Server Data Tools in SQL Server 2014? SQL Server Data Tools in SQL Server 2014I’ve seen this question a few times and it is something that can be very confusing: You’ve installed SQL 2014 (a full version, not

How to connect to TFS through authenticated Web Proxy

To fix this issue you need a custom proxy module that provides the credentials, so I created a simple DLL with this class: using System; using System.Net; namespace Rido.AuthProxy { public class AuthProxyModule : IWebProxy { ICredentials crendential = new NetworkCredential("proxy.user", "password"); public ICredentials Credentials { get

Debug cordova with visual studio code

Debug using Visual studio Code. Installation Steps: Open project folder and start set up the launch.JSON setting. Please follow the instruction here to set up the cordova extension. https://github.com/Microsoft/vscode-cordova 1. Click the debug icon in the View bar 2. click the configure gear icon 3.

High dividend yield stock

Turn Windows PC into a WiFi Hotspot using Internet Connection Sharing

In this post, we will see how to turn on Internet Connection Sharing & create a WiFi hotspot in Windows 10/8.1/8 using the netsh wlan utility, command prompt, and Wireless Hosted Network or using some free WiFi Hotspot Creator software. I just bought a Nokia Lumia 920