Softminer.net

BEGIN TRANSACTION;
update Table1
set column1 = 'value1'
where key = 1

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


--COMMIT

--ROLLBACK

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

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)]
[/recursive][/user:(*|username)]

More Info

example
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"