my verison is kinda of wordy but works with a case statement:

SELECT

CASE

WHEN RTRIM(ISNULL(col1, '')) <> ''

AND RTRIM(ISNULL(col2, '')) <>...

Jerome it seems to me you are leaving a lot out.

your example must be coming inside a cursor, right? why don't you show that part too?

your code(so far) is adding...

i...

SQLSACT (6/6/2013)

---

ikonrao (6/6/2013)

---

We have a table in which we want to know whether any of the columns has unique constraint defined.

Or if we can get create table statement for that...

have you created a job at...

Maybe the autoclose proeprty is...

i think the issue is your second statement; you only select if your variable is empty string, but you already created it?

i would do it all in a single command,...

We support an app that connects to either SQL or Oracle as well, and trip over the which-data-types-are-equivalent questions as well;

for your second question,

NUMBER(10) = int

this is my go to...

ikonrao (6/6/2013)

---

We have a table in which we want to know whether any of the columns has unique constraint defined.

Or if we can get create table statement for that table,...

I'd recommend starting with some of hte articles in the "stairways" series, here on SQL Server Central:

http://www.sqlservercentral.com/stairway/

those articles are on subjects and build up from basic information to more and...

Michelle-138172 (6/5/2013)

---

The main thing that puzzels me is why it only happens to web calling. There's never a problem running it in the Management Studio. My web dev guys can't...

so much of it depends on how it was presented, also;

As a veteran of more than a couple of posts here,

How well the question is phrased directly affects...

Michelle-138172 (6/5/2013)

---

Thanks for the advice! The thing is, all the tables involved in the proc are very static. The updates happen once a while and the proc usually works fine...

luis covered a couple important points i wanted to mention again: you'll need a new column for the ClientId in there somewhere.

we've done this in the past, and the way...

Michelle-138172 (6/5/2013)

---

I have a stored procedure that's called by a web application. Every now and then, the web call will time out for no apparent reason. But I can still...