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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | waterduckAged Yak Warrior
 
 
                                        982 Posts | 
                                            
                                            |  Posted - 2009-05-23 : 00:56:34 
 |  
                                            | ----User session halt---|<-----Process 1--------|---->commit<-Process 2--->commit |if commit no found, undo the processprocess 1 undoprocess 2 do nothingdo sql server support this function...and sorry if i posted at wrong section, i dunno where to post about this |  |  
                                    | snSQLMaster Smack Fu Yak Hacker
 
 
                                    1837 Posts | 
                                        
                                          |  Posted - 2009-05-23 : 01:18:04 
 |  
                                          | I suggest you slow down and take the time to ask your question more clearly. The abbreviated cryptic code you posted means nothing, what are you trying to do? Yes SQL Server supports transactions and IF statements, so it can probably do what you need if you take the time to explain fully what you need. |  
                                          |  |  |  
                                    | visakh16Very Important crosS Applying yaK Herder
 
 
                                    52326 Posts |  |  
                                    | waterduckAged Yak Warrior
 
 
                                    982 Posts | 
                                        
                                          |  Posted - 2009-05-24 : 22:04:38 
 |  
                                          | >"< had already solve the problem by ignoring the problem |  
                                          |  |  |  
                                |  |  |  |