Viewing 15 posts - 45,736 through 45,750 (of 59,063 total)
I'll also add that unless your database has been set to be case sensitive, then you don't need the extra overhead of all the UPPER() functions...
January 19, 2009 at 7:10 pm
Not sure it's appropriate for all of this, but if you mearly add columns to a table and the view doesn't need to be changed because it doesn't use the...
January 19, 2009 at 7:05 pm
Yes... create a format file. \" is the escape character for a single quote in the delimiter column. First character in the datafile must have a length of 1...
January 19, 2009 at 6:39 pm
Tim.Wilson-Brown (1/19/2009)
Is there any reason why you used NVARCHAR(128) rather than SYSNAME?SYSNAME would make the script more portable between versions - and enforce restrictions on content.
I agree that SYSNAME would...
January 19, 2009 at 6:36 pm
Karthikeyan.Ponniah (1/19/2009)
January 19, 2009 at 6:26 pm
Sorry... you can't have "control of flow" statements like "IF" in a view.
It could, however, be easily accomplished in a stored procedure and then you could use the result of...
January 19, 2009 at 6:20 pm
I believe the file name needs to be in quotes, folks.
January 19, 2009 at 6:11 pm
Yes... there is. Please see "Enable Trigger" and "Disable Trigger" in Books Online.
Also, I'd be very, very wary of doing such a thing. The tirgger(s) were put on...
January 19, 2009 at 6:09 pm
john.arnott (1/19/2009)
January 19, 2009 at 5:58 pm
Jacob Luebbers (1/19/2009)
Not sure if you're including "running sum" or similar problems in your question...? If so, a common reason for needing that in my experience...
January 19, 2009 at 5:52 pm
Jack Corbett (1/19/2009)
K. Brian Kelley (1/19/2009)
GilaMonster (1/19/2009)
Jack Corbett (1/19/2009)
That's probably my favorite feature of the google toolbar, spell checking just like in Word.
Firefox has that built in. Why do you...
January 19, 2009 at 5:00 pm
GilaMonster (1/19/2009)
🙂 and I'm in the middle of writing a blog rant titled "Bad Advice". It's funny when lots of people write on similar topics at once.
Maybe not so funny......
January 19, 2009 at 4:58 pm
RBarryYoung (1/19/2009)
I'll take a look at it if you want, Jeff. Just to see how much of it is about me. 😀
"You have mail". 😛
January 19, 2009 at 4:56 pm
Jeff Moden (1/19/2009)
Bob Hovious (1/19/2009)
January 19, 2009 at 3:39 pm
Viewing 15 posts - 45,736 through 45,750 (of 59,063 total)