|
-
Oct 19th, 2011, 02:25 PM
#1
Re: Searching SQL Server Management Studio 2008
 Originally Posted by techgnome
SQL Server doesn't work that way... there's apps out there that allow the "Editing" of the data in a grid, but it's just running Updates on the back end....
Don't want to mess things up? Me neither... that's why I'll put BEGIN TRANSACTION before I start mucking with the data... I'll then add a COMMIT TRANSACTION and a ROLLBACK TRANSACTION at the end and comment them out... then when the update runs, it's in a transaction... if things go wrong, I select ROLLBACK TRANSACTION and run it... if things are ok,... I can run a couple of quicjk queries to check the data and if it's good COMMIT TRANSACTION
-tg
Ah, gotcha. Sounds good. I'll do that then.
Thanks, TG.
CodeBank contributions: Process Manager, Temp File Cleaner
Originally Posted by SJWhiteley
"game trainer" is the same as calling the act of robbing a bank "wealth redistribution"....
-
Oct 19th, 2011, 02:36 PM
#2
Re: Searching SQL Server Management Studio 2008
If you wish to edit data visually in a grid, try out Toad For SQL Server (freeware).
Click this link and look at the panel on the left where it says "Freeware" under "Downloads".
You do need admin privileges to install this tool.
Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
save a blobFileStreamDataTable To Text Filemy blog
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote