I’m attempting to query and Excel spread sheet on a network share, using the openrowset function with no success.I get the following error:
I have a query which slows down immensely when i add an addition where part which essentially is just a like lookup on a varchar(500) field
I have a table named \'Customer\'. This table contains a unique Identification field for each customer named \'CustomerNo\'.
I have an application which connects to SQL Server 2000 (using a generic SQL Login开发者_StackOverflow社区 and SQL Authentication).I would like to implement some logging via triggers to track data cha
I plan to develop database application in a Android mobile ?Is that possible to connec开发者_开发知识库t a SQL Server 2000 from an Android mobile, that I could add / delete / edit records from that mo
I\'m using SQL Server 2000. My SP produces the follwing output: It sums up all Taxable Earnings (top result) and subtract it by the sum of Deductible Expenses (middle result) to get the Net Taxable
I have a table named Table1 which contains an ID and TimeStamp. Table structure IDTimeStamp 10x0000000000047509
I\'ve got a table Folders with hierarchical information about folders: FolderIDFolderNameParentID 1Folder10
Can anyone find my error in this query?I\'m using SQL Server 2000 and I want to update all entries in the CostEntry table to the corresponding value in the ActiveCostDetails table.The where clause DOE
Does anybody know what the recommend method is to copy data from one table to another using a DTS? Should we use the开发者_开发技巧 standard Insert/Select statement or a DTS transformation between two
加载中,请稍侯......