We recently upgraded a major application to Visual Studio 2010. Unfortunately, we are still using several database servers that are still running SQL Server 2000 (8.0.2055 to be precise).
I\'m running SQL Server 2000. I have a situation where users are timing out. In enterprise manager I look at the locks/ProcessIDs.
We use merge replication in one of our programs and I would like to allow our users to force synchronization of their laptops with the publisher on an as-needed basis (we are using push subscriptions)
I can\'t figure out why this query would be so slow with variables versus without them. I read some where that I need to enable \"Dynamic Parameters\" but I cannot find where to do this.
How can i pass a string delimited by space or comma to stored procedure and filter result? I\'m trying to do something like -
I have two tables \"Product\" having following structure: Produ开发者_开发问答ctID,ProductName, IsSaleTypeA, IsSaleTypeB, IsSaleTypeC
Hello I\'ve been tasked with doing a few queries on a large SQL Server 2000 database. The query I\'m having trouble with is \"find the number of people between ages 20 and 40\"
I want to get the results of a left join between two tables, with both having a column of the same name, the column on which I join. The following query is seen as valid by the import/export wizard in
I\'m trying to pivot some data in SQL Server 2000, but the user that runs开发者_如何转开发 the application only have read/write permissions.I\'ve looked the solutions posted here, but all involving cr
I\'ve created an XML file using the .Save() method of an ADODB recordset in the following manner. dim res
加载中,请稍侯......