Viewing 15 posts - 121 through 135 (of 330 total)
Ian Scarlett (9/24/2009)
It's worse, because you should then add a constraint to ensure the only allowable values were 0 or 1.
Not only that, but if you have mutliple flags, then...
September 24, 2009 at 5:37 am
The 'silent truncation of varchar variables' issue is a well-known - I believe it was subject of a recent QotD?
The reason the bit field doesn't warn is because it's an...
September 23, 2009 at 6:01 pm
WayneS (9/23/2009)
how do you do this when you're working on tuning a stored procedure?
INSERT {tablename} EXEC {procname}
🙂
September 23, 2009 at 5:26 pm
niall.baird (9/23/2009)
September 23, 2009 at 5:11 pm
RBarryYoung (9/23/2009)
Actually, it's the line-breaks in the middle of the schema.name that's messing it up. When I replaced the line-breaks with spaces, it worked fine.
It's the comments actually -...
September 23, 2009 at 1:25 pm
Anyway, the short answer is, no, you can't script an ALTER in DMO.
And the 'renamed procedure' bug still exists in the client tools, just in a different way - i.e....
September 23, 2009 at 12:26 pm
It's because it detects that the name is different to the name that the text of the procedure believes it is - but then the parser doesn't bother to parse...
September 23, 2009 at 10:22 am
That's a bit weird.
I can create this on my 2000, 2005 and 2008 instances. Not invalid syntax at all. Of course - i did replace the 'schema' with 'dbo' and...
September 23, 2009 at 10:07 am
Silverfox (9/23/2009)
Sometimes when fishing, you have to not only supply the fishing rod, but you have to hold it for them as well, until they understand how to use it.
Ooo...
September 23, 2009 at 9:36 am
Please listen to what Roy has said.
Alternatively you could choose a SQL editor that doesn't suck quite as much! 😀
September 23, 2009 at 8:04 am
Yeah I'm with Elliot on that.
The only other way I can think of that you could do it is by writing a .NET app to poll them. You could even...
September 23, 2009 at 2:06 am
in C, if (variable) will process the true statement if variable is anything other than 0. So SQL is just consistent with that in this respect.
Typically -1 is true and...
September 23, 2009 at 2:02 am
Note that snapshots on a SAN will work in the same way as snapshots in SQL Server - so there is an on-going, but slight, performance degradation, basically as the...
September 23, 2009 at 1:58 am
I've just caught up with this discussion, because the site isn't emailing me about it for some reason - which is a shame - because it's a *really* good one....
September 23, 2009 at 1:56 am
Jeff Moden (9/22/2009)
Heh... I just get lucky.
Jeff, no way.
Lucky is when you manage to do it once or twice, someone like me.
You are on a different level of SQL-ness to...
September 23, 2009 at 1:52 am
Viewing 15 posts - 121 through 135 (of 330 total)