I've only used it once, and to the best of my knowledge, my company has only used it on two projects. Both were just before the advent of LINQ to...

gary.clinton (6/2/2008)

---

I know from the residential builders that I've talked to that they rarely stick to a blueprint 100% for a lot of different reasons. I changed many aspects of...

Loner (6/2/2008)

---

However I found out the house was built to the specification, but I found out there was always something I wanted to change. That I can relate to...

I've helped build a few houses (my parents', sister's, uncle's, and a few others), as well as building several decks and what-not. The biggest difference I've seen is that once...

James Goodwin (5/20/2008)

---

I think everyone is missing the point of what is happening.

What is occuring is an automatic type conversion. If I do this:

Declare @Tmp datetime

set

mtassin (5/20/2008)

---

Try this one

Create Table #temp_test(testval varchar(10))

INSERT INTO #temp_test values('1234567890ABCD')

SELECT * FROM #temp_test

By your reasoning, I should have 1234567890 as the output.

In the case I have provided, SQL server throws...

Based on this post, I think you could do this:

Dim cnn As New ADODB.Connection

Dim cmd As New ADODB.Command

Dim strSql As String

cnn.ConnectionString = _

"Provider=Microsoft.Jet.OLEDB.4.0;" & _

...

Never seen anything like that before, but that is...

Jon Monahan (5/20/2008)

---

Seems to me that it is working exactly as expected. If you define a parameter to be a certain length, then that should be what you get. I...

Chris.Strolia-Davis (5/15/2008)

---

This kind of goes to my point of there not being levels, per se, but rather job roles and functions. An expert may not need to have the same...

sadara (5/15/2008)

---

i disagree. if the programmer can't communcate well with at least the person/people supplying him/her with the spec, s/he will quite likely code what s/he THINKS is required, rather...

In general, I love the Brazos Valley area around College Station, TX and would absolutely love to move back someday. For a long time, I wanted to go back and...

majorbloodnock (11/9/2007)

---

What I do believe to be fundamental to the requirements of a consultant, though, is that they can and do ask, correctly interpret, then deliver the solution for the...

Great article, Jacob. I think you might have mentioned this previously, but is there a limit to the number of characters an XML query will return? Also, is there a...

James,

Very well stated, and I think I agree with most, if not all, your points. I think a few more of these massive responses would probably resolve any issues of...