If I am not totally wrong, the behaviour is not due to IsNumeric itself, but to the fact that you can cast this value to money or smallmoney.

Try this:

SET NOCOUNT...

So I missed the "not" - verrrry tricky! 😀

If it was intended to be tricky, then I admit it was well done.

If not, I assume rephrasing to "ALLOW_PAGE_LOCKS is set...

I must be missing something:

Documentation states that

http://msdn.microsoft.com/en-us/library/ms188388(SQL.90).aspx

Also testing it directly in SQL2K5 resolves...

One thing to note is that the optimizer is more intelligent than in previous versions and of course they are still improving it. So if the optimizer thinks that...

Maybe something like this?

SELECT * INTO #temp FROM dbo.SourceTable WHERE

TRUNCATE TABLE dbo.SourceTable

INSERT INTO dbo.SourceTable SELECT * FROM #temp

Just for clarification - I wrote about 3 solutions.

The only one that I said would be complicated is the last one where you...

I fear you have no other option than using either CLR or dynamic SQL.

Of course you could do somthing like the following in a T-SQL function

The expression evaluator revisited (Eval...

Hi Tao, it actually does get deleted for non-clustered indexes as well.

The sentence is a...

Well, you guys did the hard part 🙂

thetodaisies (6/18/2009)

---

Hey,

please try this. the union is used to get the last record which wll not be returned in the first query

select a.* from

(select ROW_NUMBER() OVER (ORDER BY...

Tom.Thomson (6/17/2009)

---

Christian Buettner (6/5/2009)

---

I had chosen char(1) instead of varchar(1) because thats what it actually is, a fixed length string.

And I had chosen char(1) instead of nchar(1) because I think...

I must object the suggested answer.

It is possible to use 1-part names, although it does not really make sense to do this:

CREATE LOGIN Test WITH PASSWORD = 'Test123!'

CREATE USER [Test]...

Small correction: tempdb can be encrypted using TDE:

When TDE is enabled on any user database, encryption is also automatically enabled for the temporary database (tempdb). This prevents temporary objects that...

Why?

What about creating a set of stored procedures for this?

1. User executes "dbo.spuQueueJob @JobName" via OSQL to "manually schedule" the existing job by adding the job name to a queue...