And just to mention that we all have made bad decisions in our past.

Some might not admit it, but thats how we function. We're not robots.

Hello,

The proposed solution doesn't work with other languages:

SET LANGUAGE GERMAN

SELECT Datename(m, TheDate)TheMonthName, TheDate, Month(TheDate) TheMonth FROM (

SELECT '19000101' AS TheDate

UNION ALL SELECT '19000201'

UNION ALL SELECT '19000301'

UNION ALL SELECT...

Hi Jamie,

there is a footnote with the following text in the link you mentioned:

2You can upgrade an instance of SQL Server 2005 Evaluation Edition to any other edition of SQL...

I like the math here 😉

Correct answers: 72% (966)

[font="Courier New"]

--------------------------------------------------------------------------------

month(join_date) in (1,2,3,4,5,8) 61%

datename(m,join_date) like '%a%' 37%

Not in List ...

Hi Steve,

What you are saying is, that the question was about

and not about

?

Thanks!

Can someone please explain this to me?

As far as my knowledge goes, the following tree

represents a possible implementation of the tree

posted by the author. Node /1/1/2/ has been

added since...

Great Article! Just one comment on indexing table variables: It actually is possible, just a little limited: You can create unique or primary key constraints on single columns.

Example:

DECLARE @MyTable TABLE...

You're talking about this Conor? 🙂

http://www.sqlskills.com/blogs/conor/

Hello,

could you please let me know the output of the following query?

SELECT MAX(DATALENGTH(LEGAL_ENTITY), MAX(DATALENGTH(DESCRIPTION)

FROM table_1 WITH (NOLOCK)

Thanks!

Yes, the same error is raised.

I posted a comment on the blog, maybe Conor will be able to explain this.

Thanks!

Hm, should have checked this link first...

Still I am not yet convinced, or at least a little confused:

Given a table "a" with columns "cola" and "colrestricted".

User "Test" only has access...

Ah, good to know! Thanks for the heads up!

I am a little confused by this thread.

Ignore my post if you meant the same as I write now:

I am pretty sure that SQL Server does NOT make a...

Hm, I thought I had tried the SCHEMABINDING before already but that really works now.

I have also tried to use a non-deterministic function within a function - that actually is...

Like this?

CREATE FUNCTION dbo.fnDateAdd(@intA int)

RETURNS int

AS

BEGIN

RETURN @intA

END

GO

Still no luck... 🙁