I have a problem in my SQL SERVER 2000 , the server is so slow when i made any 开发者_Python百科query
I would like to query from SQL Server 2000 Database.I have got two tables. They are Purchase and PurchaseDetails. I would like to get product records with Last Purchase ID but I can\'t query with the
We have a large table (5608782 rows and growing) that has 3 columns Zi开发者_JAVA技巧p1,Zip2, distance
I\'ve got some code that runs all lovely on SQL Server开发者_C百科 2008, however I\'m forced to try it on SQL Server 2000 server, where it falls down.
i have a stored procedure that performs a join of TableB to TableA: SELECT <--- Nested <--- TableA
I am currently developing completely on a local machine and have a DTS package that on completion should run a local exe file that compresses the csv files that were just impo开发者_开发知识库rted.
I have SQL server 2000 dev edition. But it isn\'t compatible with my new win7 pro 64 bit computer. Is there a free version of 2000 that I can install on my 开发者_开发知识库64 bit pc for development?
If the itemcount property does not exactly match the number of indexed rows is that a problem? Is there a numerical way I can ensure that I have a complete full-text-index?
I am trying to make the following work: declare @ActTable as varchar(1000) declare @cPK as VarChar(100)
i have a process to move rows from one database to another. Because of some circular foreign key reference chains i cannot remove the rows from the old database, nor can i insert them into the new dat
加载中,请稍侯......