javafun

using System.Collections.Generic;
using System.Linq;

using EPiServer.Commerce.Catalog.ContentTypes;
using EPiServer.Core;
using EPiServer.Find;
using EPiServer.Find.Cms;
using EPiServer.PlugIn;
using EPiServer.Scheduler;
using EPiServer.ServiceLocation;

javafun

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web.Security.
using Umbraco.Core.Services;
using Umbraco.Web.Models;
using Umbraco.Web.PublishedCache;

/*
 * 

javafun

DECLARE @SchemaName sysname, @TableName sysname, @IndexName sysname 
DECLARE @basesql nvarchar(max), @sql nvarchar(max) 

SET @basesql = 'ALTER INDEX @1 On @2 REBUILD WITH ( FILLFACTOR = 50 ) '

DECLARE IXC CURSOR FOR 
SELECT 
    OBJECT_SCHEMA_NAME(i.object_id) As SchemaName
    , OBJECT_NAME(i.object_id) AS TableName 
    , i.name AS IndexName 

javafun

BEGIN
    set quoted_identifier on
    
    DECLARE @db varchar(max) = 'MyDB'
    DECLARE @today VARCHAR(9) = datename(w,sysdatetime())
    
    DECLARE @tableName varchar(max)
    DECLARE @indexName varchar(max)
    DECLARE @sql Nvarchar(max)
    

javafun

let 
    BaseUrl         = "https://fake-odata-api.com/v1/Entities?",
    Token           = "F4K3-T0K3N-D0NT-U5E-L0L",
    EntitiesPerPage = 1000,
 
    GetJson = (Url) =>
        let Options = [Headers=[ #"Authorization" = "Bearer " & Token ]],
            RawData = Web.Contents(Url, Options),
            Json    = Json.Document(RawData)
        in  Json,

javafun

namespace My.Common
{
  using System;
	using System.Collections.Generic;
	using System.Threading;
	using System.Threading.Tasks;

	public static class AsyncHelpers
	{
		/// <summary>

javafun

-- Create a temporary table for all documents which are published and not in the recycle bin
CREATE TABLE #Nodes (id int)
-- Delete all rows if the table exists before
TRUNCATE TABLE #Nodes

-- Insert all nodeIds from all documents which are published and not in the recycle bin
INSERT INTO #Nodes 
    SELECT N.id 
    FROM umbracoNode N
        INNER JOIN cmsDocument D ON N.ID = D.NodeId

javafun

[ImplementPropertyType("slider")]
public IEnumerable<HomeSlider> Slider
{
    get
    {
        var archetypeModel = this.GetPropertyValue<ArchetypeModel>("slider");
        return archetypeModel.Select(x =>
            {
                return new HomeSlider()
                {

javafun

function rmrf {
     <#
        .DESCRIPTION
        Deletes the specified file or directory.

        .PARAMETER target
        Target file or directory to be deleted.

        .NOTES
        This is an equivalent command of "rm -rf" in Unix-like systems.

javafun

<?php

/**
 * Class NearestValue
 * Finds the 'nearest value' of a needle in a SORTED numeric array (ascending)
 * Via https://stackoverflow.com/a/22375510/237739
 *
 * Usage:
 * $array  = [1000,2000,3000,4000,5000];
 * $needle = 1337;