In SQL Server 2005, is there a way of deleting rows and being told how many were actually deleted? I could do a select count(*) with the same conditions, but I need this to be utterly trustworthy. My first guess was to use the @@ROWCOUNT variables - but that isn't set, e.g. delete from mytable where datefield = '5-Oct-2008' se...
We have a process that needs to run every two hours. It's a process that needs to run on it's own thread so as to not interrupt normal processing. When it runs, it will download 100k records and verify them against a DB. The framework to run this has a lot of objects managing this process. These objects only need to be around when th...
I need to keep under version some large files (some Gigs). I don't need, and I can't keep under version all the version of the files. I want to be able to remove from my VCS large files version at some moment. What control version system could I use? EDIT: The files that I want to keep under version control are big .zip files or ISO...
Is it possible to delete multiple elements from a list at the same time? If I want to delete elements at index 0 and 2, and try something like del somelist[0], followed by del somelist[2], the second statement will actually delete somelist[3]. I suppose I could always delete the higher numbered elements first but I'm hoping there is a b...
hi guys how do i remove an element of an array and shift the reamining elements down so if i have an array array[]={1,2,3,4,5} and want to delete 3 and shift the rest so i have array[]={1,2,4,5} how would i go abot this in the least amount of code! ...
Hi, I can't find any information on this issue; why doesn't the following code work in IE? window.x = 45; delete window.x; // or delete window['x']; IE reports an "object doesn't support this action" error. Does it have anything to do with that iterating over window properties in IE issue? Thanks and best regards ...
I've just started using git, been used to bzr in the past. Here is my problem: I have a git repo (let's call it "default") with files A, B, and C. (I actually update others' modifications with svn.) I clone that repo to "defaultmods" and add files D, E, and F. I notice that someone updated A and C and added file G so I want those file...
How I can delete folder with subfolders (recursive deleting) in C++? ...
I used windows security to block to users the option of deleting files from the server on SVN clients. (right-click on the repository dir, and security options). now I want to commit a local directory back to the server, but I deleted one file from the dir. I get an error says I don't have permission to delete. is there any other way ...
Hi all, I was wondering if anyone could help me with a vb6 function that would delete all files within a directory (excluding subdirectories). Thanks ...
To delete all the rows in a table, I am currently doing the following: context.Entities.DeleteAllOnSubmit(context.Entities); context.SubmitChanges(); However, this seems to be taking ages. Is there a faster way? ...
My ASP.NET application has an image cropping and resizing features. This requires that the uploaded temporary image be deleted. Everything works fine, but when I try to delete an image larger than 80px by 80px I get a "File is locked by other process..." error, even though I've released all resources. Can anyone help? I'm tired of Googl...
I understand I can map a delete stored procedure to the delete method for a particular type. However, this requires passing in a retrieved object to my context's DeleteObject method. This is bad enough, but what if I want to delete 2000 rows? Can I do this with Linq to Entities without first retrieving those 2000 rows from the database...
I have following structure of the database CREATE TABLE IF NOT EXISTS `klienci` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nazwa` varchar(50) NOT NULL, `miejscowosc` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `klienci_do_trasy` ( `klient_id` int(...
Hello, Does anyone know how to copy only the first n nodes in a xml file and delete the rest using xslt? So say I only want to copy the first 10 nodes and delete the rest of the nodes that belong to the same parent. Thanks in advance! ...
I keep getting these errors when trying to delete rows from a table. The special case here is that i may be running 5 processes at the same time. The table itself is an Innodb table with ~4.5 million rows. I do not have an index on the column used in my WHERE clause. Other indices are working as supposed to. It's being done within a tr...
i have a column with buttons in a table an i am using jwuery datatable plugin. The buttons say "Remove" and the idea is that when you click on that button it deletes the current row in the table. when i call fnDeleteRow it seems to work the first time but no any further time for that row so it looks like its not really deleting the row...
How do I delete all files in a folder that has an apostrophe? for example: Baird/'s Tunnel.jpg Bach/'s Birds.jpg This isn//'t good.png I would like all those files deleted but anything that doesn't have an apostrophe to remain intact, like: this is good.jpg donotdelete.png ...
I'm using ReSharper 4.5 to execute my MSTest unit tests in VS2008. With each test run, it's creating files in this path: testProjectFolder\bin\Debug\TestResults How can I clean/delete those files from within Visual Studio? If I can't delete them from within Visual Studio, when can I expect them to be removed? EDIT: I see Visual Stu...
Hi, I have a Core Data model with 2 entities: Game and ScoreTable. A Game has an optional relationship with ScoreTable. I usually check if a game has a ScoreTable by doing: NSManagedObject *scoreTable = [myGame valueForKey: @"scoreTable"]; if (scoreTable == nil) { // wtv } And when I want to delete a ScoreTable from a Game I'll j...