No announcements
Found 3911855 threads
-
0 VotesDifference between two Delete Statement
I am analyzing Stored Procedures, found the below statement-1 (Single delete statement is having same table twice).Answered | 6 Replies | 684 Views | Created by Kiran.Y - Monday, May 23, 2016 12:23 PM | Last reply by Olaf Helper - Tuesday, May 24, 2016 10:38 AM
-
0 Votes
Select and delete as one statement.
You can do the other way, Delete first and redirect the deleted rows to another table using OUPUT ...Answered | 3 Replies | 1666 Views | Created by kicaj - Monday, January 14, 2013 6:07 AM | Last reply by Uri Dimant - Monday, January 14, 2013 8:29 AM -
2 Votes
delete statement
The JOIN will create a new table that exists only within the scope of the DELETE FROM statement.Answered | 2 Replies | 1837 Views | Created by sdnd2000 - Wednesday, August 15, 2012 12:41 PM | Last reply by --CELKO-- - Wednesday, August 15, 2012 3:55 PM -
0 Votes
CASE statement for two different select statements into #table
Hi, Unfortunately, since you trying to decide which of the two ( or more ) tables to select data from ( i.e, the FROM clause) , i am afraid this ...Answered | 2 Replies | 7904 Views | Created by ps0118mj - Thursday, April 26, 2012 1:13 AM | Last reply by Sanil Mhatre - Thursday, April 26, 2012 1:22 AM -
0 Votes
Delete statements not replicating - how to troubleshoot?
Hi, I want to inform that MSmerge_tombstone table contains information on deleted rows and allows deletes to be propagated to other Subscribers, if you want to get the ...Answered | 6 Replies | 2963 Views | Created by John McP - Thursday, December 6, 2012 10:48 AM | Last reply by Johnny Bell Jnr - Thursday, December 13, 2012 2:12 PM -
1 Votes
DELETE STATEMENT FROM SELECT RESULTS
Why do you need exists and not just delete with conditions?Answered | 7 Replies | 1002 Views | Created by joebit - Friday, July 24, 2015 3:09 PM | Last reply by Naomi N - Friday, July 24, 2015 5:32 PM -
0 Votes
delete from table and insert into table using same oledb command
It's much faster to use the OLE DB Destination to insert those records in a temporary table and then use one Execute SQL Task to delete the ...Answered | 2 Replies | 2432 Views | Created by msbito - Friday, February 28, 2014 8:11 PM | Last reply by msbito - Friday, February 28, 2014 10:03 PM -
0 Votes
Insert, update and delete statements in transactions
Transactions need to define a logical unit of work: a set of modifications that have to be atomic, which means either all of the modifications are made or none of them are ...Answered | 6 Replies | 7608 Views | Created by PCRider - Thursday, February 3, 2011 10:18 PM | Last reply by Alan Brewer [MSFT] - Friday, February 4, 2011 2:14 AM -
0 Votes
Need to compare two identical tables for Insert/ update and delete
Hi there Greetings i have to identical tables in which one will get loaded everyday. so the data between those two ...Answered | 2 Replies | 1078 Views | Created by Rhythm Devine - Wednesday, May 21, 2014 6:04 PM | Last reply by Murali dhar - Wednesday, May 21, 2014 6:12 PM -
0 Votes
asp:SqlDataSource delete command needs to have two sql statements to delete from two tables, but it only executes the first statement.
User614698185 posted Hi shriramkarpur, You have an error in your SQL syntax; check the manual that corresponds to your MySQL ...Answered | 3 Replies | 165 Views | Created by Anonymous - Monday, October 12, 2015 10:19 AM | Last reply by Anonymous - Wednesday, October 14, 2015 6:01 AM -
0 Votes
DELETE Statement timeout error
if you have child table of table1 and cascade delete is on then for every record deleted from table1 sql server also delete ...Answered | 13 Replies | 10845 Views | Created by Kasturi Rajesh - Sunday, July 26, 2009 4:27 PM | Last reply by Kasturi Rajesh - Wednesday, July 29, 2009 2:00 PM -
0 Votes
Executing multiple dynamic sql statements
Basically, we need to delete some rows based on a set of id's that have been reviewed and determined to be invalid.Answered | 3 Replies | 3935 Views | Created by kelvin_stern - Thursday, April 18, 2013 11:19 PM | Last reply by kelvin_stern - Friday, April 19, 2013 5:59 PM -
0 Votes
Message with Delete statement..
Hi, Try like this , SET NOCOUNT ON DECLARE @RowCount NVARCHAR(10) DECLARE @Tmp TABLE (Id INT IDENTITY(1,1),Name NVARCHAR(10)) INSERT @Tmp ...Answered | 3 Replies | 943 Views | Created by AshishSingh_DWH - Monday, December 9, 2013 8:53 AM | Last reply by SathyanarrayananS - Monday, December 9, 2013 9:12 AM -
1 Votes
Iterate A Table and execute statements
Have you ever thought about learning SQL and RDBMS instead of writing code like this in an invented language?Answered | 5 Replies | 902 Views | Created by Mattaniah - Monday, January 6, 2014 2:29 PM | Last reply by --CELKO-- - Monday, January 6, 2014 5:41 PM -
0 Votes
Access Code - DELETE Statement with DISTINCTROW and T-SQL
Could we use this syntax to delete records of two tables in same query ?Answered | 3 Replies | 11725 Views | Created by MSSQLServer 2008 - Monday, April 30, 2012 1:20 PM | Last reply by Jingyang Li - Wednesday, March 19, 2014 7:06 PM -
2 Votes
Basic Help Delete Statement
Please try to do the below insert your data into a temp table, then try to run the delete statement on top of it, check if the delete ...Answered | 8 Replies | 2320 Views | Created by zzpluralza - Wednesday, July 20, 2011 7:05 PM | Last reply by Surendra Nath GM - Wednesday, July 20, 2011 7:39 PM -
1 Votes
OleDB - How to rebuild indexes after DELETE-Statement
Just as an experiment, I tried updating an 844,000 record table from another table based upon matches to two indexed fields.Answered | 10 Replies | 908 Views | Created by Niklas Rammerstorfer - Monday, August 11, 2014 7:50 AM | Last reply by KevClark64 - Thursday, August 14, 2014 3:17 PM -
0 Votes
Execute SQL Statement within a table
DECLARE @A VARCHAR(MAX) DECLARE @Namesidea VARCHAR(MAX) SELECT @Namesidea = COALESCE(@Namesidea + ' ', '') + IDEA FROM ##IDEA --I am storing the whole ...Answered | 2 Replies | 2515 Views | Created by Sonic.Jessy - Tuesday, November 1, 2011 1:53 AM | Last reply by Sonic.Jessy - Tuesday, November 1, 2011 5:58 PM -
6 Votes
undo delete statement...is it possible
http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/ Thanks...Answered | 16 Replies | 160955 Views | Created by airwalker2000 - Friday, February 23, 2007 4:03 PM | Last reply by Jason_Clark03 - Saturday, February 20, 2016 6:38 AM -
0 Votes
comparing two tables for update and delete
The solution to that is to do exactly what you've done - insert to a staging table, then use a SQL command to do the update.Answered | 5 Replies | 4269 Views | Created by sqlstar - Tuesday, April 7, 2009 9:10 PM | Last reply by Todd McDermid - Monday, September 21, 2009 3:00 PM - Items 1 to 20 of 3911855 Next ›
No announcements
