Hey Barry,

I take your point about the double-ROW_NUMBER. As always, the important thing is to test.

As far as re-writing your excellent effort is concerned - thanks, but I think...

A few constructive criticisms, Barry:

Running a full-text search with a variable as a parameter can be problematic. You might have noticed that the full-text engine can provide very good...

If, for some reason, a persistent Numbers table is not an option, you can generate one as required using an in-line table function:

CREATE FUNCTION dbo.GetNumbers

...

No idea. My posted example was to meet the requirements set by hjo-483301. As I said before, there are better...

Another method, just because I like segment operators:

DECLARE @T

TABLE (

id INTEGER...

This is what the EXECUTE AS clause of CREATE TRIGGER is for.

Paul Rony

---

...the BIGINT...

When you upgrade to SQL Server 2008, you might find Change Data Capture meets you needs. It is certainly easier than creating a customized audit system using triggers.

Details: http://msdn.microsoft.com/en-us/library/bb522489.aspx

You should definitely not use sp_getbindtoken for new developments.

Books Online: sp_getbindtoken

---

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development...

There are additional system views if you are looking for a particular type of constraint.

See Object Catalog Views

Examples include:

sys.check_constraints

sys.default_constraints

sys.key_constraints

Paul

That's funny! I wonder if it was intended to be...? Hmmm!

Chris,

Wherever did you get the idea to use an alias name of iTVF?

:laugh:

Paul

Snarf

Simple:

SELECT name FROM @Data EXCEPT

SELECT name FROM @Data WHERE fruit = 'Apple';

:w00t:

Full test rig

DECLARE @data

TABLE (

name ...

Hey Jeff,

There's a faster method than that in 2005 (and I don't mean CLR):

USE tempdb;

GO

IF OBJECT_ID(N'tempdb..#Binary', N'U')

IS...

beep...beep...beep...beep.............................................beeeeeeeeeeeeeeeeeeeeeeep!