correct answer is no

I have specific problem and I solved it using dynamic temp table. Main idea is split code to two (or more) separate procedures and execute nested procedure...

when you can use CLR assembly, it is simple command in .NET System.Path.GetFileName(fullName). create and register user function, template is here http://msdn2.microsoft.com/cs-cz/library/ms131052(en-us).aspx

Hello Jacob,

I thing that sp_executesql procedure has stmt parameter of type nvarchar(MAX) (yukon), so there is "no limit" for length of statement.

I prefer usage of sp_executesql. Sometime I have performance...