GSquared (8/19/2009)

---

I have to ask, is there any reason to not simply add 8 * @b-2 to @i?

declare @i int, @b-2 bit;

select @i = 0, @b-2 = 1;

select @i +...

dmw (8/12/2009)

---

Thank you Paul and Doug for your responses.

As Paul said, I was wrong when I stated that schemas do not contain stored procedures.

I suspect tablespaces are irrelevant to...

Some links for understanding and reference:

Hilary Cotter's article: http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

Full-Text Search Q and A http://msdn.microsoft.com/en-us/sqlserver/aa336328.aspx which contains the answer to the Question: why do we need full text if we can...

Yes and No. It all depends how you set up your full-text index. Reference...

You should worry! See: http://www.sqlservercentral.com/blogs/michael_coles/archive/2008/01/20/stop-using-openxml-please.aspx

GUID is also known as a UUID. See: http://en.wikipedia.org/wiki/Uuid which also describes the Versions and how to identify them.

SQL Server GUIDs are Version "4" (random) and not Version "1" (MAC address).

An advantage for using GUIDs in a .Net application is that the value can be generated anywhere within...

Sorry, it is one of the numerous limitations in SQL Server's full-text functionality. Ref BOL: http://technet.microsoft.com/en-us/library/ms142492(SQL.90).aspx

Oracle, on the other hand, supports true SQL wildcarding (%_) of search terms. Ref:...

The System Functions are classified as Scalar Functions.

Reference BOL:

Scalar Functions: http://technet.microsoft.com/en-us/library/ms174318(SQL.90).aspx

System Functions: http://technet.microsoft.com/en-us/library/ms187786(SQL.90).aspx

Using a System Function such as CAST and CONVERT against an xml data type is permitted. Ref:

http://technet.microsoft.com/en-us/library/ms189887(SQL.90).aspx

Therefore,...

See the following post which briefly describes our process.

http://www.sqlservercentral.com/Forums/FindPost702354.aspx

More "meat" can be found in the linked posting (message 474053).

http://www.sqlservercentral.com/Forums/FindPost474053.aspx

an interesting statement in the explanation:

I think a bit more care should have been put...

I agree with all of those that chose NCHAR(1). The question stated one character of data, not one byte. The explanation is wrong as it states one byte....

You're welcome. It is one of numerous defensive measures that I've implemented. Usually resulting from the school...

Put a safety check at the beginning of your script. We have to do the same thing (i.e., upgrade 100+ databases with a new release). To avoid accidental...

The use of XQuery would be better vs. OPENXML which is generally considered to be obsolete. It is more readable which helps to avoid errors.

Additionally, OPENXML is a resource...