What is the preferred method for writing SQL Statements? Or basically in other words Is there a preferred method for writing SQL statements?
OK, based upon your question and your comments, I think I can answer your question.
First, I'll answer the question of who should write the SQL. That depends on your environment. In my environment, the software developers also write the T-SQL statements (stored procedures mostly). However, I've also worked in environments where the database administrators wrote all of the scripts. I guess my opinion would be to have the person/people with the most experience write the scripts.
Second, I'll answer the question of where the scripts should be developed. Normally, the best place to develop scripts (in my opinion) is in the SSMS editor. This allows for intellisence (in newer versions), query planning (to be sure it is optimized), and on the spot testing.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)