I am having a problem with a FreeText search, currently running on a SQL 2000 server. In a table of approximately 1.3 million rows which contain company names, I am attempting to use a FreeText query
I am using SQL Server 2000, I have a situation where I am copying data over from one table to another, the destination data table requires ea开发者_如何学运维ch Name row to be unique. Here is a quick
I have some data like at the bottom. I use SQL Server 2000 stored proc to process this data using sp_xml_preparedocument .
I have the following problem when using SQL Server 2000 The following table has around 200 rows. Company / Employee
Hella all, What I want to do is something like that, I will have an SQL table depending on my parameter,
I would like to know if there is 开发者_StackOverflow社区anyway I can add a trigger on two tables that will replicate the data to the other.
My company needs to write a query that determines when data is being entered inaccurately. We have a table in our db called \"ProductChanges\". It looks (something) like this -
We have SQL Server 2000 database with money data type columns and we have strange problem with numbers within money columns in which we store numbers with 2 decimal places. For o long time everything
i know Named Pipes are Protocols. but i have not seen even 1 example how to use them? can u开发者_高级运维 tell me what are the Named pipes ?Named pipes are one of many interprocess communication pro
I am saddled with an ERP database which lacks any foreign keys and therefore lacks referential integrity.
加载中,请稍侯......