awesome glad it worked!

if you don't specify a path (ie., just the file name), then its going to use the default directory that the process running bcp has at the time.

for instance, on...

use the server flag:

-S server_name\instance_name

Here's a complete example line with various flags:

BCP databasename.dbo.tablename out filename.DAT -c -S "servername\instancename" -T

I'm not necessarily sure the double quotes are needed but I use...

Sean Lange (2/24/2016)

---

Sergiy (2/23/2016)

---

The answer is plainly wrong.

Did anyone of you guys who think "3" is a correct answer actually run the script in a batch?

The question repeats the word...

sknox (2/23/2016)

---

Bob JH Cullen (2/23/2016)

---

This harks back to a similar post a little while back, and as a result I got this right. However, I still fail to see any...

Bob JH Cullen (2/23/2016)

---

This harks back to a similar post a little while back, and as a result I got this right. However, I still fail to see any logic...

Rich Mechaber (2/9/2016)

---

Steve Jones - SSC Editor (2/9/2016)

---

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might...

I have to agree with andy_111's sentiment, he and others...

roger.plowman (1/22/2016)

---

The flaw I'm talking about is the lack of a definitive end of line. In SQL syntax the concept of whitespace includes the end of line marker used by...

tnpich (1/11/2016)

---

I don't disagree with what's been posted previously. The practice part is essential.

As to the article, some context is needed around the statement "for most disciplines, it only...

I consistently get answers wrong, like this one, I figured...

TheSQLGuru (1/4/2016)

---

lucien.jacquet (1/4/2016)

---

My point is not to contradict your assertion that scalar functions "can be" expensive, but to suggest that your example is a worst-case scenario. Is it possible that...

I'm not understanding here, doesn't the summing operation still have to occur for each row in the "cross apply" version?

edit: Another thing that bothers me about the article is that...

Louis Davidson (@drsql) (12/21/2015)

---

In this case, the word...

same on 2012!

when I change the value of the update, it goes back to waiting for the transaction.

how cool is that?!?!

edit: set isolation mode serializable and it waits all the...