Viewing 15 posts - 3,481 through 3,495 (of 7,187 total)
An alternative worth considering, since you have a primary key constraint, is to skip the existence check, and instead to handle the error when it occurs.
John
July 3, 2014 at 9:34 am
Surely you just want to do this?
UPDATE sy01200
SET INET5 = LEFT(convert(varchar(40),EmailToAddress),LEN(convert(varchar(40),EmailToAddress))-14)
WHERE Master_Type = 'EMP'
John
July 2, 2014 at 10:44 am
If you can split it, just order the results by NEW_ID() and reconcatenate.
John
June 27, 2014 at 9:50 am
Actually, I'm puzzled. Since the value of @nKeyWord_IdArg isn't set anywhere, I'd expect it to be NULL and therefore no deletion should be attempted. Unless ANSI_NULLS is set...
June 26, 2014 at 9:20 am
I think it's this in your stored procedure:
DELETEdbo.Keywords
WHERE@nKeyWord_IdArg = @nKeyWord_IdArg
That's going to delete the whole table (unless @nKeyWord_IdArg is null).
John
June 26, 2014 at 9:06 am
MVDBA (6/26/2014)
The usage of a non-unique index is optional. Just because an index exists doesn't mean that the server will use it.
how is this different from a unique...
June 26, 2014 at 8:43 am
Should I append my t log backups or write each t log file to its on file? Of course this will make restoring harder as I will have to restore...
June 26, 2014 at 8:02 am
OK, you need to start SQL Server in a simple configuration so that it doesn't load model and msdb, then restore model. There should be plenty of resources out...
June 26, 2014 at 5:20 am
Is SQL Server running? What happens if you try to start it?
John
June 26, 2014 at 4:03 am
That's how it works. If your job is still running at its next scheduled time, it won't run again until the next scheduled time after that (unless, of course,...
June 26, 2014 at 3:26 am
Grant's link doesn't work (for me, anyway), so I'll attempt to answer your questions briefly (although you probably could answer them yourself with a bit of search engine magic).
First, no,...
June 25, 2014 at 5:40 am
Yes, it does mean that. If that's going to be a problem for you, consider taking differential backups. These backup every page (or maybe extent) that has been...
June 25, 2014 at 5:10 am
You have to restore all log backups in the chain, not just the most recent. So if you want to bring the database to the latest point possible using...
June 25, 2014 at 4:52 am
If you want to see everything from #tmpOperationalTypes, you need to put it on the left hand side of your LEFT JOIN (or change the LEFT JOIN to a RIGHT...
June 25, 2014 at 4:06 am
What do you mean by "rows with no data"? Please will you provide some examples?
John
June 25, 2014 at 3:22 am
Viewing 15 posts - 3,481 through 3,495 (of 7,187 total)