SQLkiwi

Does the stringbuilder class also suffer from the same performance 'hit' as the string object? (in this usage context)

Ninja's

Glad you liked it.

If any C# readers are looking for a versatile Split() function, look at the one in the Microsoft.VisualBasic namespace.

http://msdn.microsoft.com/en-us/library/6x627e5f(v=vs.80).aspx

SQLkiwi

Is there a reason you didn't use the Split() method for C# strings?

http://msdn.microsoft.com/en-us/library/ms228388(v=vs.80).aspx

Lynn

Thanks. Then this is an environmental property of 'compiled' TSQL of which I was not aware.

Jeff

Thank you for your patience. I must not be asking my question in the right way. Sorry. I'll try one last time.

There are two parts to the...

Jeff

I think you already identified the basic code in your articles. Since you have a test bed for performance comparison, I thought you might have tested a loop to...

Jeff,

Glad I brought a wide smile or laugh to your face/heart. But I was serious. I'm used to minimizing operations in the normal course of performance-tuning. If...

Jeff,

Thanks for writing both articles. I still don't understand why you use the CharIndex() when you could use a cursor to iterate through the delimiter positions. I think...

markybse (1/8/2008)

---

... the first exec line fails and the second exec line works. I am at a loss as to why.

DECLARE @SELECT varchar(100)

DECLARE @FROM varchar(100)

DECLARE @DynamicSQL1 varchar(8000)

DECLARE @DynamicSQL2 varchar(8000)

DECLARE...

This is an encryption of the password, not a hash.  The term 'hash' connotes a one-way process.

1. There is a redundant condition check in your example.  Once we start building the WHERE clause, we've already passed the first check, which would have prevented our getting down...

How about a .Net code example of the validation to which you allude (username character limits)?

It would been more helpful if you mentioned the use of .Net validators and gave...

also,

Select Distinct ...

will cause the output to be displayed in ascending sequence. If the first column is numeric, you can multiply the returned column by -1 to cause the...