I am sorry I was off by a year 1998 and I did not say the other RDBMS(relational database management system ) vendors cannot implement CONTAINS but I know as...

I was not clear but CONTAINS as implemented in Microsoft FULL TEXT is proprietry.  And combing it with SOUNDEX string function is redundant because some version of CONTAINS gives the...

CONTAINS is Microsoft proprietry so I don't think you can use SOUNDEX with it.  The code below may be what you can do with word sound.  Run a search for...

A GUID is not just 16bytes but binary data type that should be avoided if you can do so because a GUID will break your index and create problems while...

Try the link below for sample code using OPENXML.  Hope this helps.

http://msdn.microsoft.com/msdnmag/issues/05/06/DataPoints/default.aspx

Kind regards,

Gift Peddie

Try the links below for all you need to do localization in Asp.net and SQL Server including Unicode encoding your tables and in Visual Studio 2003.  You can do column...

To free up space you run DBCC Shrinkfile with Trunacte option, SQL Server will return space less space it marks as active log.  Run a search for DBCC Shrinkfile in...

Ignored words could be just part of the problem because FULLTEXT is Microsoft Proprietry feature you have to use FREETEXT, FREETEXTTABLE, CONTAINS and CONTAINSTABLE without functions like COALESCE.  I would...

You could just register it and manage it but the best is to backup and restore in your SQL Server 2000 which lets you check the results before taking any...

You use Float to do the calculation because most T-SQL quantitative functions are in Float but you cast the results to Decimal or Number where you can set precision and...

Try this link for a solution using DATEDIFF with time span.  Hope this helps.

http://www.stanford.edu/~bsuter/sql-datecomputations.html

Kind regards,

Gift Peddie

Cast or Convert could be an issue but the main reason there is no INT datatype in Oracle, it uses NUMBER for all numeric data types including DOULBE that is not...

SQL Server 6.5 to SQL Server 2000 can be complicated because I can write 200 pages and I have not finished with the difference in both systems.  I would use...

The VB .NET have millisecond in the FCL(framework class library) 1.1 Calendar class.  When you get less than complete datetime in SQL Server make sure you are not using Small...

Joe Celko will answer this better than I can because he explains it short and simple in SQL for Smarties why you are getting this error.  Now to your solution run...