I have a prepay phone. It has a black-and-white screen, can make and receive calls (apparently) and also send and receive...

This example was mentioned earlier. spt_values is an ordinary table in the dbo schema:

SELECT t.type_desc

FROM master.sys.tables AS t

WHERE t.name = N'spt_values'

AND t.[schema_id] = 1

...that...

I guess it depends what you consider to be a 'system table'. The term is overloaded - some would regard...

sjimmo (8/2/2011)

---

IMO you should not be asking a question about something that hasn't yet happened. At this time the command is a valid command, and the fact that ic can...

sjimmo (8/2/2011)

---

Good question, but the answer does not match the question. The question does not ask about whether the command is being depricated. The answer is actually in the link...

paul.knibbs (8/2/2011)

---

Well, yes, but the Windows collation that works is a binary collation--you'd expect that to be able to take NULLs in its stride, since it wouldn't be much use...

I'm not sure we should be singling out Canadians here. If anything, the US situation is the exception, since SQL Server uses a SQL collation by default for the...

See this link: http://msdn.microsoft.com/en-us/library/bb895265.aspx

Neither of those are system tables, they are ordinary tables that happen to be used by the system...

It's worked fine for me in the past. I also wouldn't...

brian118 (8/1/2011)

---

Found this white paper. related to SQL Server 2000.

To avoid long term maintenance of unused statistics, SQL Server 2000 ages the automatically created statistics (only those that are...

paul.knibbs (8/1/2011)

---

It's still realistically a bug, though--even if CHAR(0) is treated as an empty string in a Windows collation, REPLACE() given an empty string as its second parameter should do...

It returns 'Hello World ' in a SELECT statement, but 'Hello World Hello World' when using PRINT.

CHAR(0) is often used...

Eugene Elutin (8/1/2011)

---

Can someone guess without executing what the following SQL will return on Canada like server setup (I have the UK one) 😀

DECLARE @var varchar(max);

SET @var = 'Hello...

David in .AU (7/31/2011)

---

This article might be interesting: note the reply from microsoft at the bottom

Replace of char(0) does not work in DB with Windows collation

I know it isn't exactly...