I have gotten a number of emails from people through my blog, asking various questions about SQL Server 2000 and SQL Server 2005. While I appreciate getting these questions, please note that the best place for SQL Server support is the SQL Server newsgroups...

Datetime and smalldatetime data types can be confusing at times. For example, consider the following select statement: create table t1(c1 datetime) go insert t1 values('20010101') go select c1 + '1/1/3' from t1 go If you expected '1/1/3' to represent...

I'd like to get a feel of how many of you out there are using Browse mode (appending FOR BROWSE to your SELECT statements, and then using the additional key column metadata returned in order to update the table) directly in your applications in SQL 2000...