How to write IF Condition in Stored Procedure

[Abhishek Boga]

Hi.. 1) I was trying to create a IF Condition in stored procedure where i need to compare if old value and new value is present/not present in the database. Dont know the Syntax to write the above said query in Stored procedure. 2) I have created a variabl name 'add', 'change', 'remove'. The old value and new value are two different columns in the table. What i want is : If old value is null and new value is present then 'add' get incremented by 1, if old value is present and it has been modified in new value and if the old value string does not match with the new value then 'change' get incremented by 1, if old value is present and it has bee deleted in new value then 'remove' get incremented by 1. Kindly help me out as early as possible as these is where i stuck for the last few days and i need to resolve this soon. Abhishek

[Not Active]

Congradulations, you found the correct forum to post a database question to. Now remove the one in the ASP.NET before someone answers there.

---

only two letters away from being an asset

[Not Active]

IF( EXISTS(SELECT ?? FROM [Table] WHERE ??? ) ) And this has had you stuck for days? :omg: :wtf:

---

only two letters away from being an asset

[J4amieC]

:confused: Can you post what your database table looks like, and when you want to run this "proces" ie. is it when you update a row? How do you currently update the row? Is there just Old Value and NerwValue in the table? This question has a lot of detail, but is very confusing. As usual, please post what you have so far in the way of code.