Related Setup: https://gist.github.com/hofmannsven/6814278
Related Pro Tips: https://ochronus.com/git-tips-from-the-trenches/
Related Setup: https://gist.github.com/hofmannsven/6814278
Related Pro Tips: https://ochronus.com/git-tips-from-the-trenches/
/* ################################################################################ | |
# AUTHOR : Markus Kofler - http://www.kofler-it.com | |
# NAME : countries-for-mssql.sql | |
# DATE : 2015-06-21 | |
# Version : 1.0 | |
# COMMENT : This script creates a table within your MS-SQL-Server with all | |
# the ISO-codes for countries, phonecodes, etc. | |
# The script is based on the following github-resources: | |
# + https://gist.github.com/adhipg/1600028 | |
# + https://gist.github.com/paulochf/9616f85f3f3904f1c36f |
h2. Summary of Request: | |
Brief description of request that all stakeholders can agree to. | |
h2. Details of Request: | |
Customer list of the things necessary to accomplish the end result. | |
h2. Affected Components: | |
What existing components are impacted by this request? | |
h2. Work Involved: |
/// <summary> | |
/// Checks the Files for the specified event and category to ensure the files haven't already been generated | |
/// </summary> | |
/// <param name="eventID">Event to check for existing files</param> | |
/// <param name="fileCategory">Category of files to check the existence of</param> | |
/// <returns></returns> | |
public static bool FilesExist(int eventID, string fileCategory) | |
{ | |
bool filesExist = false; |
[core] | |
editor = \"C:/Program Files (x86)/Programmer's Notepad/pn.exe\" | |
autocrlf = true | |
[merge] | |
tool = winmerge | |
[mergetool "winmerge"] | |
cmd = wMerge.sh \"$MERGED\" \"$REMOTE\" | |
path = c:/Program Files (x86)/winmerge/winmergeu.exe | |
[diff] | |
guitool = winmerge |
Declare @sp_who2 Table | |
( | |
SPID INT | |
,Status VARCHAR(255) | |
,Login VARCHAR(255) | |
,HostName VARCHAR(255) | |
,BlkBy VARCHAR(255) | |
,DBName VARCHAR(255) | |
,Command VARCHAR(255) | |
,CPUTime INT |
declare | |
@KeyWord varchar(128), | |
@KeyWord2 varchar(128) = null | |
set nocount on | |
set @KeyWord = '' | |
--========================================================= | |
-- Temp Tables | |
--========================================================= |