SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL PROMPT Rss

   Items 1 to 20 of 43    Older >>
 

Avoid T-SQL Technical Debt using SQL Prompt Code Analysis

SQL Prompt’s new Code Analysis feature helps you discover code issues and hidden pitfalls during code development, as you type. In this article, Catherine shows how the Code Analysis feature works, and illustrates how to use the feature to improve the quality of your team’s SQL code.  Read more...
By 2018/02/23 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,833 reads

How to reformat a database in one operation

Inherited a database from another team? Changed your team policy on the way that you format SQL? What’s to stop you formatting the code of an entire database nicely, when you’re developing it? It can be done, but the process can take longer than you expect. This article will demonstrate a simple 3-step approach to reformatting a whole database to your standard, in a single operation, using SQL Compare and SQL Prompt.  Read more...
By 2018/02/19 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,864 reads

How to Test SQL Server Functions and Procedures using SQL Prompt

When writing functions or procedures, a common chore is to devise and implement the tests that ensure that the routine always works as expected.  Read more...
By 2018/02/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,199 reads

How to use the SQL Prompt snippet placeholders for selecting and copying text

There are four SQL Prompt snippet placeholders that are all about selection and copying of text. These placeholders are very handy if, for example, you have two blocks of code that need to be part of a snippet. One part you hold on the clipboard, and the other part is a block of snippet text, selected using the $SELECTEDTEXT$ placeholder.  Read more...
By 2018/02/07 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,034 reads

Finding code smells using SQL Prompt: the SET NOCOUNT problem

SQL Prompt implements two static code analysis rules to check code for potential misuse of the SET NOCOUNT command. In this post, Phil Factor explains the issue.  Read more...
By 2018/01/25 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,571 reads

Finding code smells using SQL Prompt: old-style join syntax

SQL Prompt implements a static code analysis rule which will check code automatically for occurrences of non-ANSI standard JOIN syntax - here's how it works.  Read more...
By 2018/01/18 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 3,344 reads

Finding code smells using SQL Prompt: procedures that lack schema-qualification

It is a very good idea to get into the habit of qualifying the names of procedures with their schema. It is not only makes your code more resilient and maintainable, but as Microsoft introduces new features that use schemas, such as auditing mechanisms, you code contains no ambiguities that could cause problems.  Read more...
By 2018/01/12 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 3,949 reads

6 reasons why your development team needs SQL Prompt

While SQL Prompt cannot turn an unskilled database programmer into a SQL hero, it will drive up the productivity of a typical multi-skilled development team, and reduce reliance on specialist database developers.  Read more...
By 2018/01/08 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,545 reads

How you can improve your SQL with code analysis in SQL Prompt

You could think of the code analysis feature in SQL Prompt as a machine-assisted code review. The rules that are used to check your code point out questionable areas that might be missed during regular testing.  Read more...
By 2018/01/02 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,718 reads

SQL Prompt Hidden Gem: Auto-fill the GROUP BY clause

Once you install SQL Prompt, you become aware immediately of how it enhances the native IntelliSense features of SSMS, but this can blind you to a lot of other features, hidden in various parts of the tool. In this post I share another gem of a feature that I found myself using frequently once I realize it existed!  Read more...
By 2017/12/21 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,512 reads

A day in the life of a developer with SQL Prompt

There is a lot more to SQL Prompt than IntelliSense and code completion. Tony Davis takes a developer's eye view of its features, as they slot into a typical day of database development work, covering Prompt's snippets, Actions, custom code styling, safe database refactoring, as well as safety net features such as tab coloring and tab history.  Read more...
By 2017/12/04 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,602 reads

How to record T-SQL execution times using a SQL Prompt snippet

In this quick tip, Phil Factor shares the SQL Prompt snippet he uses as a standard testbed for getting execution times for procedures and functions.  Read more...
By 2017/11/07 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,942 reads

Templates and Snippets in SSMS and SQL Prompt

Phil Factor provides an overview and comparison of SSMS templates, SSMS snippets, and SQL Prompt snippets.  Read more...
By 2017/10/30 | Source: Redgate | Category: snippets
Rating: (not yet rated)  Rate this |   Briefcase | 3,857 reads

Improved parentheses formatting in SQL Prompt 8.1

The SQL Prompt team have made some improvements to parentheses formatting in the latest version of the tool - here are the details of what's changed and why.  Read more...
By 2017/10/25 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 2,891 reads

The SQL Prompt Functionality Finder

SQL Prompt does a lot more than just intellisense - in this article, Phil Factor provides a handy table showing all of the tool's functions and where to access them.  Read more...
By 2017/10/06 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,903 reads

SQL Prompt Tip: how to control when the suggestion box pops up

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. 90% of the time this is exactly what you want, but there are other times where you just need a bit of space - Phil Factor shows how.  Read more...
By Additional Articles 2017/10/02 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,558 reads

Redgate wants your opinion

Have you tried or used SQL Prompt? Redgate is running some research on SQL Prompt pricing. Please help by filling in their short survey for the chance to win one of three licenses of SQL Prompt or a Redgate point-tool if your choice.  Read more...
By 2017/09/18 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,223 reads

The Louis Davidson custom style for SQL Prompt

In this article, Louis Davidson sticks his neck out, and offers what he believes is a sensible code formatting style, based on twenty-plus years of writing SQL. The result is the Louis Davidson custom SQL Prompt style that you can download using the link at the end of the post, try out, and adapt as required.  Read more...
By 2017/06/30 | Source: Redgate | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,069 reads

How to implement a SQL formatting standard using SQL Prompt v8

With ten programmers working on the same project, how do you agree on a standard style for formatting SQL code, and then implement it consistently? One way is through draconian rules, meeting after meeting, and the occasional sacrifice of a programmer to put the fear in those who remain. Another way is using SQL Prompt, Louis Davidson shows how.  Read more...
By 2017/06/16 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 4,597 reads

How to style your SQL using SQL Prompt’s new formatting options

Prefer tabs but your teammates use spaces? That's not a problem with the brand new formatting options in SQL Prompt. It's now possible to customize, save, and share multiple styles that you can then quickly switch between when working. Here's how it works, and how to get set up.  Read more...
By Additional Articles 2017/06/06 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 3,710 reads
   Items 1 to 20 of 43    Older >>
 
Tags
redgate (21)    
formatting (5)    
quick tips (4)    
code analysis (2)    
redgate software (2)    
snippets (2)    
static code analysis (2)    
blogs (1)    
delete (1)    
execution warnings (1)    
group by (1)    
join (1)    
product reviews (1)    
set nocount (1)    
sql (1)    
sql compare (1)    
survey (1)    
technical debt (1)    
templates (1)    
update (1)    
where (1)