No announcements
Found 3045481 threads
-
0 VotesDelete records if it is not getting inserted and also in the related tables
> Every stored proc does some kind of insert into one or more tables and involve cursors for inserting records [sic] and they are executed one after another [sic].Answered | 8 Replies | 3572 Views | Created by JR1811 - Wednesday, September 15, 2010 5:35 PM | Last reply by JR1811 - Friday, September 17, 2010 9:57 PM
-
1 Votes
Procedure Declaration for Deleting first then Inserting Deleted record into another table
-- Create date: <18/10/2012> -- Description: <Insert and Delete Records> -- ============================================= CREATE PROCEDURE [dbo].Answered | 3 Replies | 1521 Views | Created by Prasanta Kr. Biswas - Wednesday, October 17, 2012 10:30 AM | Last reply by Jingyang Li - Thursday, October 18, 2012 2:44 PM -
0 Votes
Deleting a record from a database
I can now modify and update a record and I can delete a record.Answered | 15 Replies | 4260 Views | Created by RonLevy - Friday, April 30, 2010 3:58 AM | Last reply by William Vaughn - Wednesday, May 5, 2010 1:32 AM -
0 Votes
Need to delete all child Entries from a database on deletion of parent records
Make the Foreign key relationship with Delete on Cascade 2.Answered | 1 Replies | 2031 Views | Created by kautily - Friday, September 9, 2011 10:53 AM | Last reply by Sorna Kumar Muthuraj - Friday, September 9, 2011 11:06 AM -
5 Votes
Deleting Records from Table
Hello, Try this, DELETE A FROM TableName AS A INNER JOIN TableName B ON A.Code = B.Code AND A.Name = ...Answered | 7 Replies | 3882 Views | Created by Aamir Shahzad Warraich - Friday, December 4, 2009 9:02 PM | Last reply by Pavan Kokkula - Saturday, December 5, 2009 4:07 AM -
2 Votes
Deleting extremely large number of records from database
Another solution would be to Delete your records using small batches (something like 10 000 records at a time).Answered | 3 Replies | 2479 Views | Created by Jeff Kolek - Wednesday, October 3, 2012 5:47 PM | Last reply by Jean-Nicolas BERGER - Thursday, October 4, 2012 12:23 AM -
0 Votes
"Record is deleted"
Back to topic, the problem is that Access needs to retrieve the newly inserted record back from SQL Server.Answered | 9 Replies | 3243 Views | Created by JimS-Indy - Friday, August 5, 2011 2:05 PM | Last reply by Alphonse G - Friday, August 12, 2011 1:28 PM -
3 Votes
Deleting Records
The subjects translate to rows, which requires relational division.Answered | 3 Replies | 933 Views | Created by anki2010 - Friday, April 5, 2013 10:03 PM | Last reply by Gert-Jan Strik - Saturday, April 6, 2013 12:54 PM -
0 Votes
Delete record from datagridview
Yes, unfortunately it's not a standard and reliable way. for example it doesn't work if you delete more than one row from data grid view at time.Answered | 9 Replies | 2455 Views | Created by ilovemessi - Sunday, April 18, 2010 6:57 AM | Last reply by Yasser Zamani - Mr. Help - Thursday, April 22, 2010 7:23 AM -
0 Votes
Protecting a record against delete or update
I think you can easily solve this by using triggers, here you can check before delete or update whether the particular record is allowed to do modification, you can ...Answered | 2 Replies | 4059 Views | Created by Noekk - Monday, November 2, 2009 11:09 AM | Last reply by TiborK - Monday, November 2, 2009 3:13 PM -
0 Votes
how to delete records from multiple tables.
You are best served by creating a stored procedure that takes the parent table key and remove any records from the child tables.Answered | 6 Replies | 4805 Views | Created by Debadatta Sahoo - Thursday, September 23, 2010 6:28 AM | Last reply by Mariano Gomez - Thursday, September 23, 2010 1:43 PM -
0 Votes
Removing Records from a related child entity when parent record updated
Therefore, the date that you've deleted bears no relationship to the ScheduleDates that are related to your Schedule.Answered | 6 Replies | 2007 Views | Created by DaveBarker19 - Tuesday, March 29, 2011 1:55 PM | Last reply by DaveBarker19 - Wednesday, March 30, 2011 2:00 PM -
2 Votes
Deleting records from sysservers
The error message is different: -- SQL Server 2008 T-SQL execution use [master] select * from sysservers delete from ...Answered | 4 Replies | 5516 Views | Created by RubSay - Thursday, November 12, 2009 12:08 PM | Last reply by Kalman Toth - Sunday, November 15, 2009 7:38 AM -
0 Votes
Delete SQL 2008 Record from Access 2010
> I thought I could create a simple datasheet with all the tables and fields then select the record from the datasheet and press delete ...Answered | 2 Replies | 143 Views | Created by pjscott51 - Thursday, September 11, 2014 7:33 PM | Last reply by Van Dinh - Thursday, September 11, 2014 11:14 PM -
0 Votes
Creating Related Records Filtering
Like I said: this is not necessarily a specific limitation of Lookup filters, but a broad one that limits its use to only those records which are one-hop away from the targeted ...Answered | 8 Replies | 1243 Views | Created by KawasakiRider03 - Wednesday, February 13, 2013 5:30 PM | Last reply by KawasakiRider03 - Friday, February 15, 2013 5:11 PM -
1 Votes
Bulk record deletion in CRM
Hello, My suggestion would be to create a simple .Net application using SDK to delete all records from entity.Answered | 4 Replies | 4360 Views | Created by C.Harding - Friday, September 24, 2010 11:24 AM | Last reply by C.Harding - Tuesday, October 12, 2010 8:54 AM -
3 Votes
Question related recording from soundcard.
Hi, Where should I ask a question related to recording audio from sound card out?Answered | 3 Replies | 8105 Views | Created by Jorge403001 - Tuesday, February 15, 2011 11:46 AM | Last reply by Ed Price - MSFT - Monday, October 15, 2012 9:10 PM -
0 Votes
Can't Delete Records from DB
Are you using one of the standard delete buttons from LS or a custom button?Answered | 5 Replies | 595 Views | Created by 911Dispatcher - Thursday, February 21, 2013 3:29 PM | Last reply by Justin Anderson - Friday, February 22, 2013 3:31 AM -
0 Votes
delete records
You are running a very expensive query with trying to reterive All Columns accountQuery.ColumnSet = new xrm.AllColumns(); plus don't reterive all ...Answered | 1 Replies | 4190 Views | Created by chuckc_1 - Tuesday, June 29, 2010 6:30 PM | Last reply by Muhammad Ali Khan - Tuesday, June 29, 2010 7:10 PM -
2 Votes
select deleted record join
The sql you tried has another problem, even if DELETED('uni') would work: It does also select all deleted records of the guide table, as that is ...Answered | 2 Replies | 4368 Views | Created by hon123456 - Saturday, March 26, 2011 6:46 AM | Last reply by Olaf Doschke - Saturday, March 26, 2011 8:33 PM - Items 1 to 20 of 3045481 Next ›
No announcements
