Viewing 15 posts - 9,961 through 9,975 (of 14,953 total)
My mistake. I was confusing "with execute as owner", which doesn't use single-quotes, with the rules for "with execute as 'login'", which does require single-quotes. You'd want to...
April 15, 2009 at 7:08 am
I posted a simplified explanation of each. Hopefully it's neither too simplified nor not simplified enough. Hard to judge that sometimes in these cases.
April 15, 2009 at 6:58 am
vrabhadram (4/14/2009)
Is sqlserver sql is ansi standard or ascii standard
They don't relate to the same thing. ASCII is a set of characters for computers. When you type on...
April 15, 2009 at 6:57 am
Of course, the real way to get this kind of thing from SQL is to use sets. Like this:
set nocount on;
create table #Numbers (
Number smallint identity primary key);
go
insert into...
April 14, 2009 at 3:04 pm
If you want to put the images in the database, a CLR proc should be able to do that pretty easily. It would connect to the file (filesystem object...
April 14, 2009 at 2:52 pm
GilaMonster (4/14/2009)
Lynn Pettis (4/14/2009)
Gail, see the latest on this one you were just on?
I saw it. I had a half-written, very snarky reply that I deided was better not posted....
April 14, 2009 at 2:42 pm
I guess I don't see it that way. I've had to process millions of names (used to work for a couple of direct mail marketing companies) in mail lists,...
April 14, 2009 at 2:33 pm
Todd, the problem with it is that a human being has to go through, row by row, and identify what format each name has, then record that somewhere so that...
April 14, 2009 at 12:44 pm
Not that another vote of confidence is needed, but I'm going to add one anyway. Good intro to the subject, Barry. Certainly a lot less dry than many...
April 14, 2009 at 12:02 pm
It will also depend on what recovery model your database is in. If you're in Simple, then batch-deletes probably won't cause it to grow much. If Full, then...
April 14, 2009 at 7:04 am
One thing that does sort of turn me off on this idea is an experience I had a few years ago. We were migrating a business-critical app from Access...
April 14, 2009 at 6:50 am
Are you puting the username in single-quotes? If so, don't.
April 13, 2009 at 3:18 pm
Ah. Makes sense. Thanks.
April 13, 2009 at 1:55 pm
What do you mean by performance? Most of the time, that means speed, and you already said (correctly) that truncate is faster. So, what exactly do you mean?
April 13, 2009 at 1:28 pm
Viewing 15 posts - 9,961 through 9,975 (of 14,953 total)