Viewing 15 posts - 46 through 60 (of 2,037 total)
Hi
Give this a try. (This requires your Col1 to be the primary key. If not so, is there another index on Col1?)
IF (OBJECT_ID('tempdb..#TesterACH') IS NOT NULL)
DROP TABLE...
July 17, 2010 at 1:45 pm
Hi Tim
Could you please try to explain what you want to do with your data instead of what your code shall do?
Your code has some issues with the cursors (in...
July 17, 2010 at 1:04 pm
Hi
What do you mean with "job"? Do you use SQL Agent jobs? What do they execute? If you realized the data publication over some kind of client application, you have...
July 17, 2010 at 12:43 pm
Hi Scott
m.scott.bryant (7/9/2010)
... rows of relatively long text...
Probably you want to have a look for the new SQL Server 2008 WRITE() function of VARCHAR(MAX) and VARBINARY(MAX):
July 9, 2010 at 9:20 am
Bradley Deem (7/8/2010)
Florian, thanks for the blog links those were great.
Thanks for the feedback 🙂
July 8, 2010 at 8:52 am
Hi finizi
finizi (7/8/2010)
And what about using sp_xml_preparedocument to parse XML ?
Is marked as deprecated since SQL Server 2005 and should not be used any more. Further,
The old SQL Server...
July 8, 2010 at 6:38 am
Hi Scott
Nice article about a new technology that is way too less used till now (in my opinion).
@Phil_Factor
To send data from .NET client side to a table-valued parameter, you can...
July 8, 2010 at 5:20 am
Hi Derek
There must be some issue with your exception handling. SQL Server transactions and .NET exceptions work correct. Try to remove all your custom exception handling and have a look...
July 3, 2010 at 7:24 am
July 3, 2010 at 7:18 am
Hi kramaswamy
Did you set database trust level to TRUSTWORTHY?
Is CLR enabled on your server?
Did you set your .NET assemblies permission level to "external"?
I posted a blog, last year that shows...
July 3, 2010 at 7:12 am
Hi Paul
Hard stuff for sunday, but a really great article! 🙂
Greets
Flo
May 23, 2010 at 10:24 am
Paul White NZ (5/3/2010)
Florian Reischl (5/1/2010)
Hey PaulThanks for sharing this great article!
Best wishes,
Flo
Hey Flo, thanks very much! I'm a big fan of your blog by the way.
Hey Paul
Thanks a...
May 4, 2010 at 8:25 am
Hey Paul
Thanks for sharing this great article!
Best wishes,
Flo
May 1, 2010 at 9:20 am
Hi Madhu
Try to replace all "SYSNAME" data types with "NVARCHAR(128)".
Greets
Flo
March 24, 2010 at 2:17 am
Hi Bob
I'm a little bit in a hurry at the moment, so only a very short feedback:
Great job!
Thanks
Flo
March 16, 2010 at 2:54 am
Viewing 15 posts - 46 through 60 (of 2,037 total)