{"id":110346,"date":"2026-05-08T08:55:32","date_gmt":"2026-05-08T08:55:32","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=collection&p=110346"},"modified":"2026-05-08T08:55:33","modified_gmt":"2026-05-08T08:55:33","slug":"t-sql-coding-basics","status":"publish","type":"collection","link":"https:\/\/www.red-gate.com\/simple-talk\/collections\/t-sql-coding-basics\/","title":{"rendered":"T-SQL Coding Basics"},"content":{"rendered":"\n

In this series, Robert Sheldon<\/strong> introduces you to the basics of working with T-SQL, covering such topics as readability, accuracy, performance, standardization, and other factors. The series in not intended as a prescriptive how-to list that dictates what approaches you should take, but rather as a set of guidelines for evaluating the types of issues you should address when coming up with your own approach to T-SQL coding.<\/p>\n\n\n\n

\n
\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tT-SQL Programming<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n in<\/span>\n \n T-SQL Programming <\/a>\n <\/span>\n<\/div>\n\n
\n

\n The Basics of Good T-SQL Coding Style \u2013 Part 4: Performance <\/h1>\n

\n There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tT-SQL Programming<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n in<\/span>\n \n T-SQL Programming <\/a>\n <\/span>\n<\/div>\n\n
\n

\n The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data <\/h1>\n

\n SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tT-SQL Programming<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n in<\/span>\n \n T-SQL Programming <\/a>\n <\/span>\n<\/div>\n\n
\n

\n The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects <\/h1>\n

\n Technical debt is a real problem in database development, where corners have been cut in the rush to keep to… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\t\t\t\t\t\t\t\t\t\t\t\tT-SQL Programming<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\"Simple-Talk\n\t\t\t<\/a> <\/div>\n
\n \n
\n \n \n \"Image\n Robert Sheldon<\/span>\n <\/a>\n\n \n in<\/span>\n \n T-SQL Programming <\/a>\n <\/span>\n<\/div>\n\n
\n

\n The Basics of Good T-SQL Coding Style <\/h1>\n

\n TSQL Code must work properly and efficiently. That’s not enough though. Unless you are working alone, have perfect memory and… <\/p>\n <\/div>\n

\n