The ANSI_PADDING affects the CHAR types too - surprised the hell out of me when I finally discovered why my tables weren't linking!

doing a simple select '<' + prod_code +...

Hi All,

The ANSI PADDING also has effects on Entity Framework 4!

I had written an Entity Diagram linking two tables together through a CHAR(10) field that wasn't fully populated. For...

Erm - is there a...

Ooh theres a challenge... Where do we send them? 🙂

There is a difference of losing a point fairly and squarely and being denied a point through an incorrect answer to a question.

The author deserves more than 14 pages of...

The angry Scotsman is right - it is completely wrong to make assumptions about data.

However, unlike most of the people posting on this thread who seem to cling to the...

I agree with many others that nchar(1) should be the correct answer because I am under the impression that varchars store an additional 2 bytes of data in the background...

Hi John,

You have hit the nail on the head when you are discussing Visual SourceSafe and SSMS - if you are to use the default integration then you have to...

Interesting topic - we have a similar problem with version control.

I've just had a look at the SQL Changeset and it doesn't give much benefit over just using vanilla VSS...

Hi,

At first I thought the query was really good - it would need a tweak to make it a bit better where you have nested views - so something like...

jpowers (8/1/2008)

---

Someguy (8/1/2008)

---

Example: During a break a checked a site that I often go to for information. It's a totally clean site. However, one day they had a discussion about...

I may be a touch simple and naive - but I thought if you were applying for a job then you would pass over a copy of your CV (or...

I find Jeffs answer one that works for this example - but I'm wondering how to do something a bit more...

The solution provided used a case statement where the value...

Hi,

I've just tried the delete on our sandpit machine and your absolutely right that you can't use an alias on the table where the data is being deleted but the...

I've always used the 'where exists ()' or 'where not exists ()' clause - sometimes it seems to run a bit faster than using a 'where x in (y)' -...