Or execute it with the recompile option.

exec dbo.MyProc @MyParam=MyValue WITH RECOMPILE;

Will that do what you need?

sqlnaive (8/30/2011)

---

Both you guys said same thing. My question is the result varying in sql 2005 and 2008.

select isdate('01/01/2011') or isdate('01-01-2011')

-- giving 1 in sql server 2008

select isdate('01/01/2011') or isdate('01-01-2011')

--...

The plus symbol works.

LEFT(LTRIM(MID(prefix,7,4) + phone),20)

I also noticed you have "TRIM" as a function in there. No such function in current T-SQL. Try "LTRIM" and/or "RTRIM" instead.

Does it all boil down to instant vs long-term gratification? Are money and knowledge/skill the same thing?

Yes to both.

"Concatenate" is a Denali feature as far as I know. Doesn't exist yet in SQL 2008.

GilaMonster (8/30/2011)

---

Yes, I know. And they buy...

GilaMonster (8/30/2011)

---

Jeff Moden (8/29/2011)

---

GilaMonster (8/29/2011)

---

Jeff Moden (8/29/2011)

---

GilaMonster (8/29/2011)

---

Come down and tell some people in government here that. It would...

Have you changed the default language of the server instance?

I checked, and both of the date formats you listed return 1 when I try them in SQL 2008 R2, using...

mtillman-921105 (8/29/2011)

---

GSquared (8/29/2011)

---

I read a book about that once, by some guy named...

There are some questions here that need to be answered before much can be done with this.

First, what is the "Importance" column in TableA? Can you have repeating values...

I read a book about that once, by some guy named "Marx". ...

Tom.Thomson (8/29/2011)

---

Awful.

Is there nothing that can stop it?

Maybe whover hosts the evil blog has terms of business that exclude this sort of thing (very...

Try this:

DECLARE @x XML

SET @x =

'<i18n>

<language id="en_US" version="1.0" context="US English definitions">

<entity id="MyCases" type="end_user" context="My cases" translationRequired="true">My cases</entity>

<entity id="Registration" type="admin_only" translationRequired="false">Registration</entity>

</language>

</i18n>';

--Checking if the specific node row exists in...

I tend to use brackets where needed. I use table aliases and column aliases where they are needed or where they help to read the query, like if I...

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four...