Search This Site
Older Posts
- February 2016
- June 2015
- October 2014
- June 2014
- March 2014
- July 2013
- June 2013
- May 2013
- January 2013
- December 2012
- November 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- October 2009
- September 2009
- March 2009
- February 2009
- January 2009
- December 2008
Categories
Category Archives: SQL
SQL Snapshot Notes
Sometimes when testing you need to repetitively restore a database back to a certain point in time. For very large databases the regular SQL restore can take quite a while. It seemed to me that using snapshots instead of regular … Continue reading
Posted in CodeMinder, SQL
Leave a comment
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. alter database DbName set single_user with rollback immediate go restore database DbName from disk = ‘path/to/backup.bak’ with file = … 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’
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