Skip to content

Instantly share code, notes, and snippets.

@max-mulawa
max-mulawa / CustomerTrigger.cs
Created April 19, 2011 18:39
CLRTriggers 4
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using Microsoft.SqlServer.Server;
using Weather.com.Client;
using Weather.com.Client.WeatherConditions.Forecasts;
using Weather.com.Client.WeatherConditions.Location;
namespace Mulawa.SqlServer.CLRTriggers
{
@max-mulawa
max-mulawa / BubbleSort.sql
Created April 21, 2011 13:14
Bubble Sort in T-SQL
IF OBJECT_ID('tempdb..#NumbersArray') IS NOT NULL
DROP TABLE #NumbersArray
GO
--Create T-SQL version of number array look-like
CREATE TABLE #NumbersArray
(
ArrayIndex Int PRIMARY KEY CLUSTERED,
Value Int
)
GO