Steve Jones - SSC Editor (7/12/2016)

---

It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The...

Phil Parkin (6/8/2016)

---

And why not ask them to make it idempotent while you're at it:

IF COL_LENGTH('dbo.mytable', 'col1') IS NULL

BEGIN

ALTER TABLE dbo.mytable

...

Ed Wagner (6/6/2016)

---

That sounds...

PRO TIP:

If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.

drew.allen (6/6/2016)

---

Ray K (6/5/2016)

---

WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!

BTW,...

Ray K (6/5/2016)

---

WayneS, nice to finally meet you in Philadelphia this past Saturday. Good to place faces to all the names and aliases from here in the forums!

BTW, I...

I'll be there.

Grant Fritchey (5/24/2016)

---

WayneS (5/24/2016)

---

Especially if you consider that...

Especially if you consider that you waited to...

SQL Saturday Atlanta for me.

In your article, you have:

var results = db.Customer.Where(c => c.State == "Ohio");

Which is changed to this to limit the query to only the necessary columns:

var results = db.Customer

...

You gotta just love the way ORM does this:

var results = db.Customer.Where(c => c.State == "Ohio");

what really was running behind the scenes was this:

SELECT

*

FROM

Customer

WHERE

State...

jasona.work (5/12/2016)

---

Michael L John (5/12/2016)

---

Ed Wagner (5/12/2016)

---

Agreed. Now...

Sean Lange (5/9/2016)

---

Oh lordy....here is a discussion on another forum from earlier today.

OP:

My SQL update string looks like this: "UPDATE " + tableName + " SET ??? = " +...

State 8 means that...