Skip to content
View chastain's full-sized avatar

Block or report chastain

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse

Pinned Loading

  1. tfs power tool command for unshelvin... tfs power tool command for unshelving to a different branch.
    1
    tfpt unshelve "shelfset name" /migrate /source:"$/Root/Branches/NameOfSourceBranch" /target:"$/Root/Branches/NameOfTargetBranch" /nobackup
  2. Use stuff and for xml path to select... Use stuff and for xml path to select rows into a comma separated list.
    1
    SELECT Stuff((SELECT ', ' + Name
    2
            FROM StateProvinces
    3
            FOR XML PATH ('')),1,1,'')
  3. List all columns and other relevant ... List all columns and other relevant data in a table. Found online http://weblogs.sqlteam.com/joew/archive/2008/04/27/60574.aspx
    1
    SELECT 
    2
       ORDINAL_POSITION
    3
      ,COLUMN_NAME
    4
      ,DATA_TYPE
    5
      ,CHARACTER_MAXIMUM_LENGTH