is it possible to see result of an update before

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

is it possible to see result of an update before

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-08-01 : 01:54:22

Dear All,
is there any tool or option to see the result of the update or delete query at any dash board? are there any tools like that?

what exactly i'm expecting is i'd like to see the results on a dash board before it executing in the database. is it possible?

Arnav
Even you learn 1%, Learn it with 100% confidence.

pootle_flump

1064 Posts

Posted - 2008-08-01 : 03:54:15

I'm not quite sure what you mean. Something like this:

BEGIN TRAN--open transaction

INSERT INTO MyTable--insert data
SELECT 'Some Data'

SELECT *--view the data inserted
FROM MyTable
WHERE MyCol = 'Some Data'

--Chose to commit or roll back the transaction
ROLLBACK TRAN
--COMMIT TRAN

svicky9
Posting Yak Master

232 Posts

Posted - 2008-08-01 : 06:28:27

first Option
When i do an update i generally take the Database Backup and restore it on test server run the Update on the Test server. If everything seems fine then i update the Live Database.

2nd Option
If you want to see the results before being updated .. use the instead of Trigger for Updated and check the Inserted and Deleted Tables. Hope this helps to some extent

Vic

http://vicdba.blogspot.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources