dwain.c (3/6/2013)

---

I'm tempted to violate my mantra and post a script that dumps all table names into a temp table and then CURSORs...

DavidBrown-731687 (2/26/2013)

---

I'm fully aware of the world I'm living in, thank you.

What disgusts me is the way that corporate America gets away with this deception, and tries to thwart any...

This one was easy by process of elimination, as Query 1 and Query 2 both return a 1 (addition/subtraction have same precedence, the parenthesis are superfluous) which yields the only...

GSquared (12/12/2012)

---

jeetsingh.cs (12/12/2012)

---

See Dyanmic Sql is used where we dont want to hard code the values in

our query.

For example if we wan to run this command against a database

than

Create...

Hugo Kornelis (12/6/2012)

---

I picked the right answer, but only after thinking about it for a long time - go with Books Online, or go with common sense. So I am...

I actually got this one right (according the the marked answer) it's one of the few I do get right before I research the answer.

For those talking about ON DELETE...

OCTom (11/14/2012)

---

Stefan Krzywicki (11/14/2012)

---

Steve Jones - SSC Editor (11/14/2012)

---

BTW, we are looking for some articles on deployment if any of you are interested. Not large ones, but small pieces. A...

I think you need to look into your Row Numbering. Perhaps a PARTITION BY the Group in addition to the ORDER BY.

Tom, I'm very sorry, but I must correct you. it's...

I must ask, because this section of code gives the proper answer of 105. Why does casting to anything besides an INT (TinyInt, Int, BigInt, etc.) return 105?

For example:

DECLARE...

What I've done in the past is to

1. Add a new Column with IDENTITY (1, 1) to the table

2. turn off Identity INSERT

3. copy the values from the existing column...

do a replace around it. Each character will be XML encoded and you can simply replace it back.

CELKO (9/18/2012)

---

And now you've got a salesperson and his manager on the phone to you. They need to insure an expensive (high premiums, low-risk) collectible car, which doesn't...

CELKO (9/17/2012)

---

Both concepts also assume that all data will be for current-era entities. DUNS numbers only go back to 1963. E-mail for common use, even in tech-heavy...

GSquared (8/17/2012)

I'm not going to dignify you with further discussion. I asked about the difference between the two, if you actually read what I wrote, and you respond to...