perXautomatik

## extensions.html
<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title>Extensions</title>
        <meta name="viewport" content="width=device-width">

        <style>
        body {
            margin: 0;

## WorkEdgePersonalExtensions
{"browser":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36 Edg/100.0.1185.44","version":"0.0.4","createDate":1651570362463,"bookmarks":[{"children":[{"children":[{"title":"Active Forks","url":"https://chrome.google.com/webstore/detail/bpjmkkjkcligjfbanmjnlkjffalbehpb"},{"title":"Adjust Screen Brightness","url":"https://chrome.google.com/webstore/detail/micpnhaohgdkjldlgjnpdpoafhohehbi"},{"title":"Apps Launcher for Microsoft Edge","url":"https://chrome.google.com/webstore/detail/diaoccpbblefojbbmhjgfkfdilamfhjp"},{"title":"Audio Equalizer with Volume Booster","url":"https://chrome.google.com/webstore/detail/oekedbgpagcndgdffdonbgmmjhmjocnl"},{"title":"BMStats - Stats for your bookmarks","url":"https://chrome.google.com/webstore/detail/ogdcicncikokgpojepfdikmpeghoepig"},{"title":"Bookmark Walker","url":"https://chrome.google.com/webstore/detail/jolkcmlidbppgpplmcmpkdhlefemacfd"},{"title":"Chrome Editor","url":"https://chrome.google.com/websto

## htmlExportToMd
Url: http://rendera.herokuapp.com/

## .DS_Store

      
              33 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                perXautomatik
                / .DS_Store
            
            
              Last active
              February 14, 2024 10:33
                — forked from LittleNewton/Microsoft.PowerShell_profile.ps1
            
              
                PowerShell 7.1 启动命令
              
          
            View raw
        
    
## sql-pass-temp-table-to-exec-sp_execute.sql
/*What you have here is not Temporary Table, but a Table-Valued Parameter.
--Url: https://stackoverflow.com/questions/38823690/pass-temp-table-to-exec-sp-executesql#:~:text=You%20can%20use%20table-valued%20parameters%20to%20send%20multiple,parameters%2C%20but%20they%20must%20be%20of%20declared%20type.
Table-valued parameters are declared by using user-defined table types. You can use table-valued parameters to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure or function, without creating a temporary table or many parameters.

sp_executesql does support table-valued parameters, but they must be of declared type.
*/
-- So, first we must declare User-Defined Table Type
CREATE TYPE udtYB_Test AS TABLE(GSName nvarchar(100), THour time, NumOfTransactions int);
GO

## files-in-a-folder.sql
DECLARE @Path nvarchar(500) = 'E:\Test' --Change the path

DECLARE @FindFile TABLE
 (FileNames nvarchar(500)
  ,depth int
  ,isFile int)

INSERT INTO @FindFile
EXEC xp_DirTree @Path,1,1

## .gitattributes
# Stick this in your home directory and point your Global Git config at it by running:
#
#  $ git config --global core.attributesfile ~/.gitattributes
#
# See https://tekin.co.uk/2020/10/better-git-diff-output-for-ruby-python-elixir-and-more for more details
# Use this line at your own risk
# * text=auto

# Editor save files
# (these should be in your gitignore)

## gist:3c9712ba4663e49cbe3961eb67791ea0

      
              0 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                perXautomatik
                / gist:3c9712ba4663e49cbe3961eb67791ea0
            
            
              Last active
              October 19, 2023 13:42
            
              
                Powershell - convert XML to CSV - Stack Overflow
              
          
              We couldn’t find that file to show.
              
            
## continuouslyAndStartIt.ahk
;
; AutoHotkey Version: 1.x
; Language:       English
; Platform:       WinXP/7
; Author:         studotwho
;
; Script Function:
;	Restarts the iTeleportConnect service if it hasn't started - this usually happens if your
;   wireless network interface hasn't started when iTC tries to connect.
;

## get-selected-text-ask-for-help-autohotkey-community.ahk
#c::
oCB := ClipboardAll  ; save clipboard contents
Send, ^c
ClipWait,1

< do whatever you originally wanted with selected text in "clipboard" variable >

ClipBoard := oCB         ; return original Clipboard contents
return
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="UTF-8">
	<title>Extensions</title>
	<meta name="viewport" content="width=device-width">

	<style>
	body {
	margin: 0;
	/*What you have here is not Temporary Table, but a Table-Valued Parameter.
	--Url: https://stackoverflow.com/questions/38823690/pass-temp-table-to-exec-sp-executesql#:~:text=You%20can%20use%20table-valued%20parameters%20to%20send%20multiple,parameters%2C%20but%20they%20must%20be%20of%20declared%20type.
	Table-valued parameters are declared by using user-defined table types. You can use table-valued parameters to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure or function, without creating a temporary table or many parameters.

	sp_executesql does support table-valued parameters, but they must be of declared type.
	*/
	-- So, first we must declare User-Defined Table Type
	CREATE TYPE udtYB_Test AS TABLE(GSName nvarchar(100), THour time, NumOfTransactions int);
	GO
	DECLARE @Path nvarchar(500) = 'E:\Test' --Change the path

	DECLARE @FindFile TABLE
	(FileNames nvarchar(500)
	,depth int
	,isFile int)

	INSERT INTO @FindFile
	EXEC xp_DirTree @Path,1,1
	# Stick this in your home directory and point your Global Git config at it by running:
	#
	# $ git config --global core.attributesfile ~/.gitattributes
	#
	# See https://tekin.co.uk/2020/10/better-git-diff-output-for-ruby-python-elixir-and-more for more details
	# Use this line at your own risk
	# * text=auto

	# Editor save files
	# (these should be in your gitignore)
	;
	; AutoHotkey Version: 1.x
	; Language: English
	; Platform: WinXP/7
	; Author: studotwho
	;
	; Script Function:
	; Restarts the iTeleportConnect service if it hasn't started - this usually happens if your
	; wireless network interface hasn't started when iTC tries to connect.
	;
	#c::
	oCB := ClipboardAll ; save clipboard contents
	Send, ^c
	ClipWait,1

	< do whatever you originally wanted with selected text in "clipboard" variable >

	ClipBoard := oCB ; return original Clipboard contents
	return