Skip to content

Instantly share code, notes, and snippets.

View astannard's full-sized avatar

Andy Stannard astannard

12 followers · 8 following
  • Derby, UK
View GitHub Profile
@astannard
astannard / gist:7319388
Created November 5, 2013 13:59
Select XML node data from a column of type XML
SELECT TOP 1 [xmlColumnName].value('(//NodeName)[1]','varchar(max)') AS NameOfData
FROM [TableWithXMLColumn]
WHERE
Id = @id
@astannard
astannard / gist:7022405
Last active December 25, 2015 18:39
T-SQL Cursor
DECLARE @Id int
DECLARE TableCursor CURSOR LOCAL FAST_FORWARD FOR
SELECT Id
FROM dbo.TABLENAME
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @Id
WHILE @@FETCH_STATUS=0
@astannard
astannard / gist:6914157
Created October 10, 2013 06:55
ios / android mobile html camera access
<input type="file" capture="camera" accept="image/*" id="cameraInput">
@astannard
astannard / gist:5984913
Created July 12, 2013 14:32
Ye Old Typography
body {
background-color: #f5f5dc;
border-top: solid 10px #333;
color: #4c362a;
font-size: 1.1em;
font-family: 'Alegreya', serif;
margin: 0;
padding: 0;
}
@astannard
astannard / gist:5813627
Created June 19, 2013 11:38
Drop cap style
.dropCap:first-letter {
font-weight: 600;
font-size: 6em!important;
line-height: .8;
display: block;
float: left;
height: 0.6em;
margin: 5px 5px 5px -7px;
}