Gabriel Porras gabrielizalo

## header.sql
-- =============================================
-- Author:      <Author Name>
-- Create date: <Creation date>
-- Description: <Description>
-- Example:     <Example code to execute>
-- History:     <Modification date> > <Description of the modification>
--              <Modification date> > <Description of the modification>
-- =============================================

## DateTime.cs
DateTimeVariable.ToString("yyyyMMdd")

## DateInternationalFormat.sql
SELECT CONVERT ( VarChar(8), GETDATE(), 112)

## GetDateWithoutTime.sql
SELECT CAST ( FLOOR ( CAST ( GETDATE() AS DECIMAL (12, 5) ) ) AS DATETIME )

## Promises.js
// Definition
// ----------------
var p = new Promise(function(resolve, reject) {

	// Do an async task async task and then...

	if(/* good condition */) {
		resolve('Success!');
	}
	else {

## jQueryExists.js
// if element exists
if($('selector').length){ //do something }

// if element does not exist
if(!$('selector').length){ //do something }

## AntiClickJacking.html
<style>
    body{display:none;}
</style>
<script>
    if(self==top){
        document.getElementsByTagName("body")[0].style.display="block";
    }else{
       top.location=self.location;
    }
</script>

## NoCache.cs
// Http 1.1
getCurrentResponse().setHeader("Cache-Control", "no store, no-cache, must-revalidate");

// Http 1.0
getCurrentResponse().setHeader("Pragma", "no-cache");

// Prevents caching at the proxy server
getCurrentResponse().setDateHeader ("Expires", -1);

## functionCall.ts
(<any>window).MyExternalFunction();

## EasilyNavigateWithinASectionOfPages.php
// Taken from: https://speckyboy.com/wordpress-snippets-secondary-navigation/
/*
This code makes for a great secondary navigation menu that could be used, for example, within a sidebar. It automatically displays the pages within the current section you’re browsing.
As an example, let’s say your site has an About Us page, with subpages for History, Mission Statement and Staff. Users will be able to more easily navigate between the various pages within this section as a bulleted list of links.
*/
<?php
if (  $post->post_parent ) {
    $children =  wp_list_pages( array(
        'title_li' =>  '',
        'child_of' =>  $post->post_parent,
	// Definition
	// ----------------
	var p = new Promise(function(resolve, reject) {

	// Do an async task async task and then...

	if(/* good condition */) {
	resolve('Success!');
	}
	else {
	// if element exists
	if($('selector').length){ //do something }

	// if element does not exist
	if(!$('selector').length){ //do something }
	<style>
	body{display:none;}
	</style>
	<script>
	if(self==top){
	document.getElementsByTagName("body")[0].style.display="block";
	}else{
	top.location=self.location;
	}
	</script>
	// Http 1.1
	getCurrentResponse().setHeader("Cache-Control", "no store, no-cache, must-revalidate");

	// Http 1.0
	getCurrentResponse().setHeader("Pragma", "no-cache");

	// Prevents caching at the proxy server
	getCurrentResponse().setDateHeader ("Expires", -1);
	// Taken from: https://speckyboy.com/wordpress-snippets-secondary-navigation/
	/*
	This code makes for a great secondary navigation menu that could be used, for example, within a sidebar. It automatically displays the pages within the current section you’re browsing.
	As an example, let’s say your site has an About Us page, with subpages for History, Mission Statement and Staff. Users will be able to more easily navigate between the various pages within this section as a bulleted list of links.
	*/
	<?php
	if ( $post->post_parent ) {
	$children = wp_list_pages( array(
	'title_li' => '',
	'child_of' => $post->post_parent,