In order to redirect - you'd need to have a separate file (probably a text file) be the destination of the error. You don't want it to run into...

welcome, happy to help!

Forget loops. You're in SQL server now, not in procedural code.

update CL

set u_resp=EVALOR

from cl

inner join (

SELECT ...

You can put in the port using the following syntax:

IPAddress,Port

or

Name,Port

As in

127.0.0.1,1542

You really don't need a cursor for this. I'd suggest some code, but there are enough errors in your code it's hard to tell what table is getting updated...

By the way - did you actually look in the place it told you to? What's wrong with that row?

from your error messages:

Is that the last...

Good luck!~

Just move your condition into the count. As in...

Select id, count(case when param=1 then 1 else null end) as myCount

from mytable

Group by ID

If they're worried about statistics - why not just drop the table and recreate it? If truncate works, then you don't have any FK constraints.

There should be 0 stats...

Jeff Moden (3/11/2008)

---

I say again... Just like SQL allows itself to take any form... or Java... or...

I've seen some absolutely gorgeous VBS both formatting wise and code wise. ...

Good luck from another schmoe on that same long road.....

The place where the social contract seems to be broken is that compared to 2000, the licensing prices quadrupled, and for a product that has "half the shelf life". ...

I agree with above posts.

To answer your initial question however - if you restrict the size, and your log backup strategy isn't aggressive enough, then you run the risk of...

Developer Edition is good enough, all right. As a matter of fact - it's the same (functionally) as Enterprise Edition, so it might actually be considered by some to...

The concern is that functions tend to hurt performance quite a bit. Although they might improve readability, they have a tendency to take the ability to leverage things like...