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