How to kill a SQL Server.

Allow developers to use sp_xml_preparedocument in their stored procedures. It gives the enterprise edition of SQL2000 the concurrency of MSDE.

REPLICATE('0',7-LEN(YourResult))+ CAST(YourResult AS VARCHAR)

Of course this is old hat now but I used a VB app and the ADO Stream object whenever I had to load image files.

Building labourers earn more than computer programmers and everyone always needs a builder!

The BOL entry for sp_xml_preparedocument warns that the XML parser will take 1/8th of the memory available for SQL Server.

For retrieving small amounts of data in simple XML format SQL2000...

SELECT Test1.ID

FROM Test1 LEFT JOIN Test2 ON Test1.ID = Test2.ID

WHERE Test2.ID IS NULL

UNION ALL

SELECT Test2.ID

FROM Test2 LEFT JOIN Test1 ON Test2.ID = Test1.ID

WHERE Test1.ID IS NULL

It might not be in the version of BOL that comes with the SQL2000 CD. An updated to BOL is available as a free download from Microsoft.

If you are interested in phonetic matching then try http://aspell.net/metaphone/

If memory serves me correctly Lawrence Philips went on to work for Verity, the search engine people