- 1. Hide a Drive per User in Windows 7
- / Windows OS /
- ... 2000 O 16384 4000 P 32768 8000 Q 65536 10000 R 131072 20000 S 262144 ...
- Created on 28 March 2014
- 2. Search a database with SOUNDEX
- / Databases /
- ... containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by 4000 characters in a variable (so I couldn't store it in a local variable). So the idea here is to run the below ...
- Created on 11 October 2012
- 3. Copy a table with structure and data into a temporary table
- / Transact-SQL /
- ... -- Variables used DECLARE @ColName varchar(50); DECLARE @TableName varchar(50); DECLARE @TableDeclaration nvarchar(4000); DECLARE @SqlToExecute nvarchar(4000); -- Set variable default ...
- Created on 03 August 2012
- 4. DataJumble - Shuffling characters in a data value
- / Transact-SQL /
- This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...
- Created on 01 August 2012
- 5. Strip HTML in MySQL
- / MySQL /
- ... the following: SET GLOBAL log_bin_trust_function_creators=1; DROP FUNCTION IF EXISTS fnStripTags; DELIMITER | CREATE FUNCTION fnStripTags( Dirty varchar(4000) ) RETURNS varchar(4000) DETERMINISTIC ...
- Created on 06 December 2011
- 6. Win32 Constants
- / AutoHotkey /
- ... = $00000000 Const WS_POPUP = $80000000 Const WS_CHILD = $40000000 Const WS_MINIMIZE = $20000000 Const WS_VISIBLE = $10000000 Const WS_DISABLED ...
- Created on 05 July 2011
- 7. Homepage (default)
- Created on 10 January 2018
- 8. Slideshow Addon
- Created on 30 November -0001