lmu92 (5/4/2009)

---

You probably need to...

I have to vote for It Depends. I tend to do it both ways, it all depends what I am doing. For single variable sets, I tend to...

Indianrock (5/4/2009)

---

If installing a sql service pack has the potential to break things, then it should be installed in Dev and tested first. Perhaps this is no longer a...

Please post the complete query.

Have you tried this:

SELECT description

FROM tab1

where description = '''%' + @Description + '%'''

Please note, that is three single quotes at the start and end.

I don't think you'd win such a lawsuit. If auto updates are enabled, you have instructed the OS load patches/updates. If you haven't, and it installed along with...

Did you try this:

where

isdate(LTRIM(RIGHT(t1.sent_info, 19)))= 0

First, let me clarify that I learned about lmgtfy from another poster on SSC (name unknown); but it looks like I've created a monster by using it myself as it...

I prefer the...

For what you are trying to accomplish the SUM() OVER (PARTITION BY ...) does not work as you have found. These window functions haven't been fully implemented for that...

happycat59 (5/3/2009)

---

Before choosing to remove BUILTIN\Administrator, please be aware that this is the default mechanism used by SQL Server to grant the local admin group SysAdmin privilege to SQL Server....

I'm slightly confused as to what is being asked. In addition to data and expected results, the DDL for the tables involved and your current code would also be...

RBarryYoung (5/4/2009)

---

PhilM99 (5/4/2009)

---

Sorry if I have offended the...

Hearing the differences between Oracle and SQL Server, although interesting, is getting a bit old.

Let's remember one crucial thing SQL Server Oracle.

Let's stop complaining about the differences and just...

laailalalaa (5/4/2009)

---

hello

how can i cancel the operation that triggered.. a trigger in some cases?

say i have an after insert trigger for a Students(id int, name varchar(15)) table and if i...