Click here to Skip to main content
16,019,740 members
Home / Discussions / Database
   

Database

 
AnswerRe: Handling big tables Pin
Eddy Vluggen22-May-12 9:32
professionalEddy Vluggen22-May-12 9:32 
AnswerRe: Handling big tables Pin
jschell23-May-12 10:46
jschell23-May-12 10:46 
GeneralRe: Handling big tables Pin
V.23-May-12 20:45
professionalV.23-May-12 20:45 
Questionerd concepts Pin
mido_h_8921-May-12 22:34
mido_h_8921-May-12 22:34 
AnswerRe: erd concepts Pin
Mycroft Holmes21-May-12 23:53
professionalMycroft Holmes21-May-12 23:53 
QuestionError while declaring a cursor Pin
VC_RYK21-May-12 19:16
VC_RYK21-May-12 19:16 
AnswerRe: Error while declaring a cursor Pin
R. Giskard Reventlov22-May-12 6:23
R. Giskard Reventlov22-May-12 6:23 
QuestionHow to get delete/Update row + SQL Pin
jojoba201118-May-12 22:00
jojoba201118-May-12 22:00 
Hi,
How can i get the full record that is delete/Update via exec sp_trace_setevent @TraceId

I mean:
I have table with this columns
Id int ,Name nvarchar(max) ,Family nvarchar(max)
with the values:
1,jojoba,alin<br />
2,babk,babyi

...
now i when i update like this:
SQL
UPDATE    tblName
SET              Name='okki', Family='koki' where Id=2


now I wanna this in my trace:
2,babk,babyi Deleted<br />
2,ooki,koki  Inserted

AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen19-May-12 0:42
professionalEddy Vluggen19-May-12 0:42 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201119-May-12 4:38
jojoba201119-May-12 4:38 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen19-May-12 5:05
professionalEddy Vluggen19-May-12 5:05 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201120-May-12 2:42
jojoba201120-May-12 2:42 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen20-May-12 3:03
professionalEddy Vluggen20-May-12 3:03 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201120-May-12 17:38
jojoba201120-May-12 17:38 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen21-May-12 4:30
professionalEddy Vluggen21-May-12 4:30 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 20:11
jojoba201121-May-12 20:11 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen22-May-12 0:52
professionalEddy Vluggen22-May-12 0:52 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 3:22
jojoba201122-May-12 3:22 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen22-May-12 8:50
professionalEddy Vluggen22-May-12 8:50 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 23:24
jojoba201122-May-12 23:24 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen23-May-12 0:16
professionalEddy Vluggen23-May-12 0:16 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201123-May-12 3:37
jojoba201123-May-12 3:37 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen23-May-12 8:23
professionalEddy Vluggen23-May-12 8:23 
AnswerRe: How to get delete/Update row + SQL Pin
Mycroft Holmes20-May-12 12:55
professionalMycroft Holmes20-May-12 12:55 
AnswerRe: How to get delete/Update row + SQL Pin
Corporal Agarn21-May-12 0:49
professionalCorporal Agarn21-May-12 0:49 

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.