One of my previous tips about executing stored procedures generated lots of mail about SQL statements. This week, I want to answer questions from those emails and share some tips from readers. I’ll continue this discussion for several weeks...
In a stock-for-stock transaction, PeopleSoft Inc. plans to buy The Vantive Corp., a move that will enhance PeopleSoft’s ability to offer comprehensive e-business solutions and robust applications...
A. e.g. select datepart(wk,'19990323') returns 13 when it should be 12...
A. This only happens with Unicode columns because Unicode sorts/compares are based on the Windows standard which effectively ignores the hyphen character...
A. This is an issue with a SQL 7.x client not being able to check the NT credentials in use. It always calls the SSPI interface to check this. ...
A. This is caused by a mis-matched set of NT networking layer files. It is usually caused by installing new network protocols from the original NT media to a machine with NT service packs already installed. Re-installing the latest/installed NT...
A. You can do this by converting the values to binary...