Writing SQL statements

Question

0.00/5 (No votes)

See more:

What is the preferred method for writing SQL Statements? Or basically in other words Is there a preferred method for writing SQL statements?

Posted 18-Jun-12 13:10pm

Member 9138159

Updated 18-Jun-12 14:26pm

v2

Add a Solution

Comments

[no name] 18-Jun-12 19:54pm

Do you think you could be a tad more specific?

Member 9138159 18-Jun-12 20:28pm

What I was wondering is, Does SQL have a preferred method for writing SQL Statements or is it left up to the administration to make up their own SQL statements?

[no name] 18-Jun-12 21:03pm

Still not clear. I do not really understand what it is that you are asking but the answer, I think, is it depends. I would like nothing better then to let the DBAs write all the queries and SPs that they want. In my situation the DBAs do not do anything except make backups. I am the one that writes SPs for them. They do not give me access to the databases but expect me to troubleshoot data errors for them. Not to mention the network admins that do not know anything about folder permissions.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tim Corey · Accepted Answer · 2012-06-18T16:23:00

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.