Click here to Skip to main content
15,565,403 members
Home / Discussions / Database
   

Database

 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 23:24
professionalGuyThiebaut19-Feb-14 23:24 
QuestionUpdate Database for C# application Pin
PDTUM19-Feb-14 7:06
PDTUM19-Feb-14 7:06 
AnswerRe: Update Database for C# application Pin
David Mujica19-Feb-14 9:39
David Mujica19-Feb-14 9:39 
AnswerRe: Update Database for C# application Pin
PDTUM20-Feb-14 6:54
PDTUM20-Feb-14 6:54 
QuestionRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 4:55
Nicholas Swandel21-Feb-14 4:55 
AnswerRe: Update Database for C# application Pin
PDTUM21-Feb-14 6:50
PDTUM21-Feb-14 6:50 
GeneralRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 7:20
Nicholas Swandel21-Feb-14 7:20 
Questionbegin tran in sql server 2008 Pin
vkEE19-Feb-14 6:22
vkEE19-Feb-14 6:22 
Hello All,

I am performing an update statement. About 100,000 rows.

Just before my update statement I had, "begin tran". There was an issue with the update statement, and errored out. Do I have to issue a "rollback" statement to make sure there is not a partial update or does using begin tran make sure a partial update does not occur?

Thanking you!
AnswerRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:02
professionalGuyThiebaut19-Feb-14 7:02 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 7:13
vkEE19-Feb-14 7:13 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:27
professionalGuyThiebaut19-Feb-14 7:27 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 7:43
vkEE19-Feb-14 7:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:32
professionalGuyThiebaut19-Feb-14 8:32 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 9:25
vkEE19-Feb-14 9:25 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 9:43
professionalGuyThiebaut19-Feb-14 9:43 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 9:52
professionalEddy Vluggen19-Feb-14 9:52 
GeneralRe: begin tran in sql server 2008 Pin
Ananth A21-Feb-14 1:43
Ananth A21-Feb-14 1:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut21-Feb-14 1:56
professionalGuyThiebaut21-Feb-14 1:56 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 9:25
professionalEddy Vluggen19-Feb-14 9:25 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 9:30
vkEE19-Feb-14 9:30 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 9:47
professionalGuyThiebaut19-Feb-14 9:47 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 9:59
vkEE19-Feb-14 9:59 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 11:26
professionalGuyThiebaut19-Feb-14 11:26 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 9:59
professionalEddy Vluggen19-Feb-14 9:59 
AnswerRe: begin tran in sql server 2008 Pin
Corporal Agarn19-Feb-14 9:22
professionalCorporal Agarn19-Feb-14 9:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.