Viewing 15 posts - 55,546 through 55,560 (of 59,067 total)
That returns the max data length for those items you want to update... not all items. That not-with-standing, it looks to me like you have well under the 8000 characters...
August 2, 2007 at 5:02 pm
Not really... if you create a # temp table (non-global) in a proc, that temp table will be available in any proc below that because it's the same session (although it's...
August 2, 2007 at 8:32 am
Hari... are you calling the function using SQL that's embedded in the GUI code? If so, Koji is absolutely correct... the code must add the outer quotes as part of...
August 2, 2007 at 8:23 am
Heh... you're right, David.
But it was easy to find... just clicked on the author's name and looked at the previous posts for...
August 2, 2007 at 8:11 am
WOW!! Even I felt the wrath of God smite me on... |
August 2, 2007 at 8:01 am
I'm sorry Vamshi... I didn't mean to sound so outragous about what you wrote. It's outstanding that you're diving into a book (although you might want to get a different...
August 2, 2007 at 7:53 am
If you're partially migrated, do it in SQL Server, now. If you continue to build new things in the old system, you will simply prolong the migration and maybe even...
August 1, 2007 at 10:09 pm
Not if you sink the boat in the process. There may be a reason the manager wants things done a certain way (it's usually political). Of course, the manager just...
August 1, 2007 at 10:03 pm
Very nicely done, Peter. Nasty fast, too!
August 1, 2007 at 9:57 pm
What the max DATALENGTH of the text column, please?
August 1, 2007 at 9:39 pm
If you copied the data through a linked server to a temp table like you did with OPENROWSET, the speed would be the same.
The problem with OPENROWSET is that the...
August 1, 2007 at 8:52 pm
Heh... so write the triggers to send him personal pages and emails when the triggers fail
That will make him keenly aware of...
August 1, 2007 at 8:39 pm
I'm thinking that it's a bad idea to use a trigger for this... what happens when one of the servers is down for some reason? You got it, the other...
August 1, 2007 at 8:36 pm
This looks a lot like homework or an interview question... please post what you've tried and we'll go from there.
August 1, 2007 at 8:27 pm
Viewing 15 posts - 55,546 through 55,560 (of 59,067 total)