Click here to Skip to main content
15,888,521 members
Home / Discussions / Database
   

Database

 
AnswerRe: Optimizing TSQL Stored Procedure Code, need a better alternative for performance. Pin
PIEBALDconsult1-Jan-12 16:07
mvePIEBALDconsult1-Jan-12 16:07 
GeneralRe: Optimizing TSQL Stored Procedure Code, need a better alternative for performance. Pin
Nadia Monalisa1-Jan-12 21:29
Nadia Monalisa1-Jan-12 21:29 
AnswerRe: Optimizing TSQL Stored Procedure Code, need a better alternative for performance. Pin
Shameel1-Jan-12 18:40
professionalShameel1-Jan-12 18:40 
GeneralRe: Optimizing TSQL Stored Procedure Code, need a better alternative for performance. Pin
Nadia Monalisa1-Jan-12 21:30
Nadia Monalisa1-Jan-12 21:30 
AnswerRe: Optimizing TSQL Stored Procedure Code, need a better alternative for performance. Pin
unclejimbob5-Jan-12 11:52
unclejimbob5-Jan-12 11:52 
QuestionTable not updated when value not set Pin
lionelcyril29-Dec-11 19:36
lionelcyril29-Dec-11 19:36 
AnswerRe: Table not updated when value not set Pin
Md. Marufuzzaman29-Dec-11 21:01
professionalMd. Marufuzzaman29-Dec-11 21:01 
AnswerRe: Table not updated when value not set Pin
jschell30-Dec-11 9:04
jschell30-Dec-11 9:04 
lionelcyril wrote:
When the condition c_count = 0 is encountered I have not set the value for juriscode (ie i hv not mentioned that condition).

I have noticed that when no value is set to the v_juriscode variable the table row is not updated, I wanted to know why this happens.


Precluding the previous answer that statement is contradictory.

If the update runs, the where condition is satisfied and no error occurs then an update did happen. There is no alternative.

If an update occurs then a value will be updated. There is no such thing a "no value" unless you mean null (presumably you don't mean spaces.) If you didn't set a value then null is used.

If you don't want an update if there is no value then use the code from the other response.
If you want an update with a different value then set v_juriscode to a default value before you execute the rest of the code.
QuestionHow to auto detect row version, if some one update manually Pin
Md. Marufuzzaman29-Dec-11 19:25
professionalMd. Marufuzzaman29-Dec-11 19:25 
SuggestionRe: How to auto detect row version, if some one update manually Pin
Jan Steyn29-Dec-11 20:59
Jan Steyn29-Dec-11 20:59 
GeneralRe: How to auto detect row version, if some one update manually Pin
Md. Marufuzzaman29-Dec-11 21:28
professionalMd. Marufuzzaman29-Dec-11 21:28 
GeneralRe: How to auto detect row version, if some one update manually Pin
PIEBALDconsult30-Dec-11 4:13
mvePIEBALDconsult30-Dec-11 4:13 
AnswerRe: How to auto detect row version, if some one update manually Pin
Eddy Vluggen30-Dec-11 5:26
professionalEddy Vluggen30-Dec-11 5:26 
QuestionGrant permissions to role on another role Pin
Danzy8329-Dec-11 13:27
Danzy8329-Dec-11 13:27 
AnswerRe: Grant permissions to role on another role Pin
coded00729-Dec-11 15:23
professionalcoded00729-Dec-11 15:23 
QuestionHow Can We Avoid Creatng Closed Pathes in our Design Pin
yousefshokati29-Dec-11 1:15
yousefshokati29-Dec-11 1:15 
AnswerRe: How Can We Avoid Creatng Closed Pathes in our Design Pin
Chris Meech29-Dec-11 7:04
Chris Meech29-Dec-11 7:04 
AnswerRe: How Can We Avoid Creatng Closed Pathes in our Design Pin
SilimSayo29-Dec-11 8:43
SilimSayo29-Dec-11 8:43 
AnswerRe: How Can We Avoid Creatng Closed Pathes in our Design Pin
Eddy Vluggen29-Dec-11 8:54
professionalEddy Vluggen29-Dec-11 8:54 
GeneralRe: How Can We Avoid Creatng Closed Pathes in our Design Pin
yousefshokati30-Dec-11 22:56
yousefshokati30-Dec-11 22:56 
AnswerRe: How Can We Avoid Creatng Closed Pathes in our Design Pin
Eddy Vluggen31-Dec-11 4:31
professionalEddy Vluggen31-Dec-11 4:31 
QuestionSending Column Name From SP to C# App Pin
AmbiguousName28-Dec-11 1:04
AmbiguousName28-Dec-11 1:04 
AnswerRe: Sending Column Name From SP to C# App Pin
hypermellow28-Dec-11 2:03
professionalhypermellow28-Dec-11 2:03 
AnswerRe: Sending Column Name From SP to C# App Pin
AmbiguousName28-Dec-11 2:18
AmbiguousName28-Dec-11 2:18 
AnswerRe: Sending Column Name From SP to C# App Pin
Karthik Harve28-Dec-11 18:44
professionalKarthik Harve28-Dec-11 18:44 

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.