Hey there, glad to meet again with a simple enquiry. I learned that a recursive stored condition may cause crash of sql application as this kind of procedure will keep calling by itself until a condition is met? What is a good practice to handle these procedures? Thanks a lot.
Yes there has to a termination point, I believe recursive CTEs naturally terminate after 1000 recursions but this can be changed. Its the same with looping, unless there is something to end the loop it will keep running.
Not when you don't need to, nvarchar allows you to add unicode characters, if those will never exist in the data, there's no need to use it, that will just cost you storage
