sql server - SQL - update, delete, insert - Whatif scenerio -

-

i reading article other day showed how run sql update, insert, or deletes whatif type scenario. don't remember parameter talked , can't find article. not sure if dreaming.

anyway, know if there parameter in sql2008 lets try insert, update, or delete without committing it? log or show have updated. remove parameter , run if behaves expect.

i don't know of sql2008 specific feature sql service supports transactions can this:

  1. start transaction ("begin transaction" in tsql)
  2. the rest of insert/update/delete/what-ever code
  3. (optional) select statements , such if needed output result of above actions, if default output step 2 (things "x rows affected") not enough
  4. rollback transaction ("rollback transaction" in tsql)
  5. (optional) repeat testing code show how things without code in step 2 having run

for example:

begin transaction -- make changes delete people name 'x%' delete people name 'd%' exec some_proc_that_does_more_work -- check db state after changes select count(*) people -- undo rollback transaction -- confirm db state without changes select count(*) people

(you might prefer optional "confirm" step before starting transaction rather after rolling back, i've done way around keeps 2 likely-to-be-identical sections of code easier editing)

if use rather sql2008 specific technique should transferable other rdbs (just update syntax if needed).


Comments

Post a Comment

Popular posts from this blog

SAP Web Service from .NET via WCF -

-
i'm trying consume sap web service .net via wcf. i've generated proxy , have configured app.config file. here test code: webservicesap.ztest_rfcclient mywcfservice = new webservicesap.ztest_rfcclient("myendpoint"); mywcfservice.clientcredentials.username.username = "<username>"; mywcfservice.clientcredentials.username.password = "<password>"; webservicesap.ztestrfc parameter = new webservicesap.ztestrfc(); parameter.testinput = "this simple test"; webservicesap.ztestrfcresponse response = mywcfservice.ztestrfc(parameter); console.writeline(reponse.testoutput); console.readline(); the ztestrfc sap method simple function accepts input string, , outputs: "result: <the input string>" when call ztestrfc method, got null value in variable response. soap messages seem fine. soap request <messagelogtracerecord> <httprequest xmlns="http://schemas.microsoft.com/2004/06/servic...
Read more

Optimized Line drawing in QT -

-
i new qt. working on graphics. i using qwidget drawing graphics(for drawing graphics in qwidget paint event). need draw background , foreground graphics. background fixed graphics. foregrounds drawing lines. each 100 millisecond need draw 20points. drawing time 8 sec. total need draw 1600 points (total points represents contentious line). i using qtimer invoke drawing in each 100ms. first few drawing drawn fast. in middle of drawing it's become slow. the problem need draw foreground , background in each 100ms. please me fix problem. if 1 have sample code please provide. in advance. is there way draw partial area ie. particular modified region of graphics? qpainter-drawing can slow without hardware support. using qgraphicsview won't if lines visible, since internally uses qpainter anyway. if have draw 20 new points (or lines) per update , per update background gets cleared have render again, there few things try: 1) disable background autofill. see...
Read more

datetime - str to time in python -

-
time1 = "2010-04-20 10:07:30" time2 = "2010-04-21 10:07:30" how convert above string time stamp? i need subtract above timestamps time2-time1 . for python 2.5+ from datetime import datetime format = '%y-%m-%d %h:%m:%s' print datetime.strptime(time2, format) - datetime.strptime(time1, format) # 1 day, 0:00:00 edit: python 2.4 import time format = '%y-%m-%d %h:%m:%s' print time.mktime(time.strptime(time2, format)) - time.mktime(time.strptime(time1, format)) # 86400.0
Read more