-
-
-
Recent Posts
Recent Comments
- Jason Pettys on The Speed of Trust: Chapter 2
- Jason Pettys on The Speed of Trust: Chapter 2
- Katie Banley on The Speed of Trust: Chapter 2
- Mark Hathaway on The Speed of Trust: Chapter 2
- Jason Pettys on User Experience: Find the Send Button
Archives
Categories
Meta
Category Archives: SQL
Force a SQL Restore
Really tired of having to google this and piece it together every time I want it, so I’m posting it here. .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, “Courier New”, courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } … Continue reading
Posted in CodeMinder, SQL
Leave a comment
Update a SQL table’s XML value to insert a node
Sometimes a snippet of example code is all that’s needed: update MyTable set XmlColumn.modify(‘ insert <Description>This is a description</Description> as last into (/xpath/to/parent)[1] ‘) where SomeValue = ‘whatever’ .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, “Courier New”, … Continue reading
Posted in CodeMinder, Programming, SQL, XML
Leave a comment
SQL Injection Joke (with a lesson)
At a recent team stand up meeting I passed along a joke I caught on twitter: A SQL Injection walks into a bar, starts to quote something but stops, drops a table, then dashes out. The joke is a … Continue reading
Posted in Programming, SQL
Leave a comment
Drop a SQL column default constraint that has been implicitly named
CodeMinder: to remind myself of stuff that I usually have to look up each time I do it. Notice the unnamed default in the following line: alter table test add col1 int not null default 1 This creates a default … Continue reading
Posted in CodeMinder, Programming, SQL
Leave a comment
Update a SQL table’s XML value to remove nodes
CodeMinder: to remind myself of stuff that I usually have to look up each time I do it. To delete all PersonAlternativeName nodes from XmlColumn of the People table: with xmlnamespaces( ‘http://mydomain.com/person/extension/0.1′ as px) update People set XmlColumn.modify(‘delete //px:PersonAlternateName’)
Posted in CodeMinder, Programming, SQL, XML
Leave a comment
Select multiple XML nodes out of each row in a SQL table
CodeMinder: to remind myself of stuff that I usually have to look up each time I do it. If a People table has a column named XML, and the XML column may specify multiple PersonAlternativeName entities, then to get all … Continue reading
Posted in CodeMinder, SQL, XML
Leave a comment