Click here to Skip to main content
14,304,598 members
   

Database

 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
RedDk7-Mar-13 12:13
memberRedDk7-Mar-13 12:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy7-Mar-13 19:45
memberDavidduraisamy7-Mar-13 19:45 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy8-Mar-13 0:54
memberDavidduraisamy8-Mar-13 0:54 
GeneralRe: I keep running into xml format issues in various editors ... please advise Pin
RedDk8-Mar-13 8:31
memberRedDk8-Mar-13 8:31 
Questionhow to unloch table in sql Pin
mhd.sbt7-Mar-13 7:38
groupmhd.sbt7-Mar-13 7:38 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 8:01
mveEddy Vluggen7-Mar-13 8:01 
GeneralRe: how to unloch table in sql Pin
mhd.sbt7-Mar-13 21:15
groupmhd.sbt7-Mar-13 21:15 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 22:31
mveEddy Vluggen7-Mar-13 22:31 
mehdi.sabet wrote:

ok but this is when that you use COMMIT end of my related code.

but i dont use COMMIT tran in my code.

First, it's a lousy example; there's no way that the server can "guess" whether it should be rolled back or comitted automatically. Second, there is nothing to commit or rollback, since a SELECT statement doesn't change the data. Don't use a transaction when selecting. Also, set <a href="http://msdn.microsoft.com/en-us/library/ms188792.aspx">XACT ABORT</a>[<a href="http://msdn.microsoft.com/en-us/library/ms188792.aspx" target="_blank" title="New Window">^</a>] to ON. Also, don't lock an entire table, unless really, really required.

mehdi.sabet wrote:
and if use this code you can see that this table is lock:

Code to close it on SO[^]
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: how to unloch table in sql Pin
mhd.sbt7-Mar-13 22:51
groupmhd.sbt7-Mar-13 22:51 
Questiona query by less performnace Pin
mhd.sbt7-Mar-13 4:00
groupmhd.sbt7-Mar-13 4:00 
AnswerRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 8:02
mveEddy Vluggen7-Mar-13 8:02 
GeneralRe: a query by less performnace Pin
mhd.sbt7-Mar-13 22:46
groupmhd.sbt7-Mar-13 22:46 
GeneralRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 22:49
mveEddy Vluggen7-Mar-13 22:49 
GeneralRe: a query by less performnace Pin
mhd.sbt7-Mar-13 23:08
groupmhd.sbt7-Mar-13 23:08 
AnswerRe: a query by less performnace Pin
Mycroft Holmes7-Mar-13 12:04
memberMycroft Holmes7-Mar-13 12:04 
GeneralRe: a query by less performnace Pin
mhd.sbt7-Mar-13 22:56
groupmhd.sbt7-Mar-13 22:56 
QuestionHow to use sql server database into oracle Pin
Arun kumar Gautam7-Mar-13 1:05
memberArun kumar Gautam7-Mar-13 1:05 
AnswerRe: How to use sql server database into oracle Pin
Sandeep Mewara7-Mar-13 1:10
mentorSandeep Mewara7-Mar-13 1:10 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 1:13
memberDavidduraisamy7-Mar-13 1:13 
GeneralRe: How to use sql server database into oracle Pin
mhd.sbt7-Mar-13 21:06
groupmhd.sbt7-Mar-13 21:06 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 21:30
memberDavidduraisamy7-Mar-13 21:30 
GeneralRe: How to use sql server database into oracle Pin
mhd.sbt7-Mar-13 21:59
groupmhd.sbt7-Mar-13 21:59 
QuestionCreate a table for prices Pin
MedZi20106-Mar-13 18:10
memberMedZi20106-Mar-13 18:10 
AnswerRe: Create a table for prices Pin
Anish_Chakraborty7-Mar-13 0:43
memberAnish_Chakraborty7-Mar-13 0:43 
GeneralRe: Create a table for prices Pin
Davidduraisamy7-Mar-13 1:10
memberDavidduraisamy7-Mar-13 1:10 

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.