My question is pretty simple but I just couldn't find the setting to change this. I am using Visual Studio 2008 as my SQL stored procedure editor. After I switched to Window 7, the SQL style in VS2008 changed and is now all over the place compare with the styles I used to have in Window XP VS2008. It shouldn't be the Operating System problem, but could anyone please help me of actually how / where to change the indentation styles for SQL? I tried to look into VS2008 options but everything in vain.
When I use the SQL editor Query Builder in VS2008 to build query, after pressing the OK in the query builder, the SQL is automatically set in this style. Here is example of what I have now.
SELECT USER, DEPT
FROM TblEmployee
WHERE DEPT = 'Accounting'
There are all these spaces / indentation that make my SQL all over the place especially with nested or more complicated query. I want it to be like this without all the redundant the spaces,
SELECT USER, DEPT
FROM TblEmployee
WHERE DEPT = 'Accounting'
Someone please tell me where do I change this setting. Thank you.