Posted on 3:32 AM by Softminer and filed under

update Table1
set column1 = 'value1'
where key = 1

update Table2
set column2 = 'value2'
where key = 2



-- First run with "BEGIN TRANSACTION"
-- If it was OK then run "COMMIT"
-- If it was not OK then run "ROLLBACK"

Posted on 4:05 AM by Softminer and filed under

TO be able to see files checked out you need to install TFS power tools

after that you will be able to run command prompt for visual studio

tf status itemspec [/collection:TeamProjectCollectionUrl] [/login:username,[password]] ([/workspace:workspacename[;workspaceowner]]|[/shelveset:shelvesetname[;shelvesetowner]])[/format:(brief|detailed)]

More Info

tf status "$/Project/MyApp" /collection:http://tfs:8080/tfs /user:myuser /recursive /workspace:myworkspace

To view it in Visual studio GUI

Right click on the top most folder that you want to start in
Choose "Find In Source Control"
Choose "Status"
Check "Recursive"
Check "Status"
Enter userid in the "Display files checked out to:" box (i have to include my domain, i.e. domain\userid)
Click "Find"