Viewing 15 posts - 1,651 through 1,665 (of 49,571 total)
Most likely there is blocking. Can you check sys.dm_exec_requests when there's load and see what the query is waiting for?
March 16, 2017 at 5:26 am
March 16, 2017 at 5:25 am
March 16, 2017 at 5:22 am
You don't.
Insert the row into the remarks table, obtain the ID assigned to that row, put that into the customer table.
March 16, 2017 at 5:20 am
Then the necessary permissions were added for the account when the login was changed.
March 15, 2017 at 9:33 am
March 15, 2017 at 6:09 am
That's not going to work for what you want. That query, if there are ANY rows in employee with ID between 1 and 2000, then the insert won't run.
You...
March 15, 2017 at 5:28 am
March 15, 2017 at 5:25 am
Then you'll need to use option 2.
March 15, 2017 at 5:23 am
The answer for 2) makes no sense, you can't update when rows don't exist in one table. I'll assume you meant 'insert them' for (2) and 'update to make the...
March 15, 2017 at 4:04 am
What, exactly do you want to do with the rows that are:
1) In employee, not in backup.employee?
2) Not in employee, in backup.employee?
3) In both?
March 15, 2017 at 3:49 am
I'm confused.
You say you want to update this table from another DB, but the query you're running is an insert, not an update.
The reason you're getting the ...
March 15, 2017 at 3:23 am
Please note: 3 year old thread.
March 15, 2017 at 3:22 am
PearlJammer1 - Tuesday, March 14, 2017 9:58 AMDoes it even matter ?
No.
From 2012 to SQL 2014 would be a problem (well, failover...
March 14, 2017 at 10:36 am
What was confusing was your use of 'query'. A script (multiple queries) executes top to bottom, a single query doesn't.
March 14, 2017 at 8:10 am
Viewing 15 posts - 1,651 through 1,665 (of 49,571 total)