Viewing 15 posts - 31 through 45 (of 48 total)
@grovelli-262555 A CLR Stored Procedure is a Visual Studio.Net assembly that can be included into a SQL Server 2005+ database and its methods used as stored procedures, functions,...
February 9, 2011 at 8:40 am
Glen,
Nice article for a home solution. In most corporate environments however, xp_cmdshell calls will not be allowed - certainly not in mine! - however you could easily replace the calls...
February 9, 2011 at 2:42 am
Thank you. It was a great learning experience for me in terms of writing style and content. All the feedback was beneficial and my future articles will surely improve as...
February 9, 2011 at 2:10 am
Apolgies, didn't answer the todoid and personid question. I'd expect the business/application layer to do this, as if the application was passing me a todoid for the wrong personid then...
February 8, 2011 at 3:23 pm
Again, this is because my procedure also removes gaps in the sequence, hence why it updates all the records. If you try my procedure with different parameters and look at...
February 8, 2011 at 3:10 pm
Unfortunately the funky code is very efficient. The problem with stored procedures with a lot of IF statements in is that they do not cache well, as the compiler stores...
February 8, 2011 at 2:06 pm
Thank you Amy and apologies for the initial typo (which has now been corrected). I have learned a lot about the article writing style from the comments and the whole...
February 8, 2011 at 9:59 am
I think I used zero as the starting sequence due to all the C# programming I have been doing lately - and the hardened C# community would surely spit on...
February 8, 2011 at 9:55 am
I would agree that this is a good introductory article on DISTINCT and will help many a newbie. A minor section on performance may have been beneficial but it is...
February 8, 2011 at 2:31 am
Oh I'm looking forward to that! Currently looking into the new datetimeoffset data type in 2008 to replace my "convert to local date via a utc hour and minute offset...
February 8, 2011 at 2:15 am
James,
I would agree that maybe the delete routine would be a better place for the zero re-numbering and that this does over-complicate the routine somewhat.
James
February 7, 2011 at 2:57 pm
Thank you for the kind comments, they are all very useful. This is the first article I have tried to write and judging by the feedback, I'm on the right...
February 7, 2011 at 12:19 pm
Blimey, well, it proves that old problems never actually go away but the code to deal with them just evolves.
Current reading up on the Merge command.... Thank you for pointing...
February 7, 2011 at 9:40 am
The added complexity is because my procedure always adjusts the sequence number so that it is continuous and zero based. Your proc works fine but you won't end up with...
February 7, 2011 at 9:30 am
The added complexity is because my procedure always adjusts the sequence number so that it is continuous and zero based. Your proc works fine but you won't end up with...
February 7, 2011 at 9:29 am
Viewing 15 posts - 31 through 45 (of 48 total)