{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 淡お忘 的问题《SQL Formatting Tool [duplicate]》','https://www.manongdao.com/q-1236900.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Possible Duplicate:
SQL Formatter for SQL Management Studio
So Visual Studio has a command like Format Document [Ctrl+K, Ctrl+D] is there something similar for SQL Management Studio?
If not is there any other product out there, anywhere, that can help with this?
We have hundreds of these we have to go through in a rather short time span, and as it we spend WAY to much time reformatting them due to poor initial formatting quality.
We are using Microsoft SQL 2008.
You could try SQL Formatter (webbased). I think there was a similar question some time ago.
Edit: Yup, duplicate question.