Maintainable Dynamic SQL - by DaverSG

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 795690 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 8/1/2013 8:22:52 AM
Access Restriction Public


There has got to be a better way of working with dynamic SQL in SQL Server Management Studio and Visual Studio.  String concatenation is very error prone and difficult to maintain.
Can you imagine all the man hours wasted developing and re-coding dynamic SQL?  Of course, you need to do a lot of research into the best way to implement this; client side or server side?  You also need to prevent SQL injection, bad performance, etc. 
Sign in to post a comment.
Posted by Microsoft on 11/1/2013 at 10:50 AM
Thank you for submitting this feedback. After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.
Thanks again for providing the product suggestion and continued support for our product.