I have a table with over 3000000 entries, and i need to delete 500000 of them with given ID s. My idea is to create a query like:
DELETE FROM TableName WHERE ID IN (id1, id2, ...........)
which I generate with a simple C# code. The question is: is there a limit to how many values I can set in the array of ID s.
如果有人能更好地实现这一删除,那么我就对想法持开放态度。
At the end my solution which works not so bad: 1. Sorted the ID s (to save server paging) 2. Created with C# code query s with 500 ID s in them. 3. sent the query s one by one.
我假定,当我与1 000+毫升的电梯服务器一道工作时,处理盘问的时间正在放慢(在你在舱面服务器上运行的所有电问都正在处理和优化之后)。
我希望能帮助某个人
如果能够以任何比较(如<编码>WHERE ID < 1000000<>/code>)确定你的身份证,你可以
INSERT them into a temp table with multiple inserts and thenJOIN this temp table to yours但插入可能会产生问题。 你们应该检查这一点。 你们怎样才能加快这项工作?
I need to declare 12 decimal variables, corresponding to each month s year, with a cursor I sum values to this variables, then later I Update some sales information. I don t know if sql server has ...
Does anyone have experience with using indexed view in MS SQL Server 2008? I am trying to find out how does indexed view affect performance of insert / update statements, that are adding / updating ...
In Microsoft SQL Server Management Studio 2008, is there a secret to be able to edit one row based on a key? There s an option to do "Edit Top 200 Rows", but what if I want to select some other row ...
Has anyone any experience moving a number of identical SQL Server databases (with unique data) from individual local servers to a single internet based server? We currently have 10 companies using ...
While altering a table (removing a column) in SQL Server 2008, I clicked the Generate Change Script button and I noticed that the change script it generated drops the column, says "go" and then runs ...
I have a Money column in my SQL Server 2008 table. In my below query how can I round it to nearest 5$ select FineAmount from tickets Thanks
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
I am starting a project to create an "object versioning" feature for our software (.NET 3.5 / SQL Server 2008), basically it needs to do this: a user is looking at a customer: last name is "Smith-...