SQL Prompt by Keyboard

Phil Factor shares a handy keyboard shortcut diagram that reveals some of the most useful of Prompt's keyboard shortcuts, and a wallchart showing every piece of Prompt functionality, what it does, where to find it in the various menus, and of course its keyboard shortcut. Read more

Controlling how SQL Prompt Formats your Code: The Knobs and Dials

Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt. Read more

Finding Correlated Rows Using EXISTS or COUNT

Should you always use EXISTS rather than COUNT when checking for the existence of any correlating rows that match your criteria? Does the former really offer "superior performance and readability". Louis Davidson investigates. Read more

SQL Prompt 10: What’s New?

Tony Davis reviews the major new features of SQL Prompt 10, included improved 'ranking' of its code auto-completion suggestions, tab history improvements to make it easier to find 'lost' code, and auto-fixing of code that breaks code analysis rules. Read more

SQL Productivity with SQL Prompt

There is an old joke that upgrading to the latest SQL Server is wasted on some DBAs, because they will still stick mainly to what worked in SQL Server 2005. This type of DBA is becoming rare, in my experience, but there is still some truth in the idea that many of us don’t get Read more

Neglecting to Use, or Misusing, the RETURN Keyword (BP016)

Phil Factor demonstrates the correct use of the RETURN keyword in stored procedures or batches, to pass back a non-zero RETURN code to the calling process, informing it of the error. He also explains some of its misuses. Read more

Problems with adding NOT NULL columns or making nullable columns NOT NULL (EI028)

Phil Factor explains the problems you might encounter when adding a non-nullable column to an existing table or altering a column that contains NULL values to be non-nullable. He demos a migration script that can deploy such changes safely. You might also learn that in an archaic form of the Scots language, used in Cumberland, the number 17 is "tiny bumfit"; I think the tiny bumfit bus goes from Penrith to Carlisle. Read more

Why you Should Avoid Using the @@IDENTITY Function

Phil Factor demonstrates why SQL Prompt has a 'Best Practice' rule (BP010) that checks for use of the @@IDENTITY function, and suggests less error-prone ways to get the latest identity values used in a table. Read more

Problems Caused by Use of the SQL_VARIANT Datatype

Phil Factor illustrates the 'quirks' of the SQL_VARIANT datatype and why it's best to investigate when SQL Prompt alerts you to its use. It is only safe to store data as a SQL_VARIANT, if you explicitly convert it to its true type before you use it. Read more

The ‘= NULL’ Mistake and other SQL NULL Heresies

The SQL Prompt Best Practice rule checks whether a comparison or expression includes a NULL literal ('NULL'), which in SQL Server, rather than result in an error, will simply always produce a NULL result. Phil Factor explains how to avoid this, and other SQL NULL-related calamities. Read more

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Product articles SQL Prompt

SQL Prompt by Keyboard

Controlling how SQL Prompt Formats your Code: The Knobs and Dials

Finding Correlated Rows Using EXISTS or COUNT

SQL Prompt 10: What’s New?

SQL Productivity with SQL Prompt

Neglecting to Use, or Misusing, the RETURN Keyword (BP016)

Problems with adding NOT NULL columns or making nullable columns NOT NULL (EI028)

Why you Should Avoid Using the @@IDENTITY Function

Problems Caused by Use of the SQL_VARIANT Datatype

The ‘= NULL’ Mistake and other SQL NULL Heresies

Product Articles

University

Community Forums

Events & Friends

Simple Talk