Pinned Loading
-
tfs power tool command for unshelvin...
tfs power tool command for unshelving to a different branch. 1tfpt unshelve "shelfset name" /migrate /source:"$/Root/Branches/NameOfSourceBranch" /target:"$/Root/Branches/NameOfTargetBranch" /nobackup
-
Use stuff and for xml path to select...
Use stuff and for xml path to select rows into a comma separated list. 1SELECT Stuff((SELECT ', ' + Name
2FROM StateProvinces
3FOR XML PATH ('')),1,1,'')
-
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 1SELECT
2ORDINAL_POSITION
3,COLUMN_NAME
4,DATA_TYPE
5,CHARACTER_MAXIMUM_LENGTH
7 contributions in the last year
Day of Week | February Feb | March Mar | April Apr | May May | June Jun | July Jul | August Aug | September Sep | October Oct | November Nov | December Dec | January Jan | February Feb | ||||||||||||||||||||||||||||||||||||||||
Sunday Sun | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Monday Mon | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Tuesday Tue | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Wednesday Wed | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Thursday Thu | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Friday Fri | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Saturday Sat |
Less
No contributions.
Low contributions.
Medium-low contributions.
Medium-high contributions.
High contributions.
More