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

Content with tag SQL PROMPT Rss

   Items 1 to 20 of 32    Older >>
 

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,766 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,737 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,824 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,819 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,462 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,181 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 | 4,815 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,519 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,629 reads

How to implement a T-SQL code formatting standard using SQL Prompt

Louis Davidson shows how to save a defined SQL formatting style as a shareable template that you can quickly share with your coworkers.  Read more...
By Additional Articles 2017/05/02 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 5,239 reads

Quick SQL Prompt Tip – using the CDB snippet

There are a number of built-in snippets for SQL Prompt, and many of them are very simple, but they can greatly speed up your T-SQL coding if you learn what they are. Data Platform MVP Steve Jones shows how to make best use of the popular CDB snippet, for CREATE DATABASE statements, to save you time, but also ensure databases are created with the standard settings your organization may have, every time.  Read more...
By 2016/11/29 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,436 reads

Code completion, formatting and refactoring for SQL Server

A common misconception is that Redgate’s SQL Prompt is ‘just’ a code completion tool. While this is indeed at the heart of SQL Prompt, there are a host of features that will help you and your team work more quickly and efficiently, freeing you up to concentrate on the important stuff. Take a whistle stop tour around SQL Prompt in this short demo.  Read more...
By 2016/09/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,304 reads

SQL Prompt 7.2 – Now With Execution Warnings!

Redgate’s code completion tool SQL Prompt now provides you with a handy warning if you try to execute an UPDATE or DELETE statement without a WHERE clause. Bob Pusateri explains why he loves this added layer of protection, and why you should too.  Read more...
By 2016/06/02 | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,838 reads

SQL Prompt Tips #7 - Begin End Highlighting

This SQL Prompt tip shows you how code highlighting makes it easier to find which items match up with each other.  Read more...
By Steve Jones 2015/11/25 (first published: 2015/01/26) | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 3,038 reads

Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts

There may be some people who enjoy repetitive typing, but Grant Fritchey doesn't. He's always preferred SQL Prompt. The standard snippets suit developers fine but aren't so DBA-oriented, so he set about asking the SQLServerCentral community what they typed in the most, and set about producing a set of DBA snippets with the results.   Read more...
By Additional Articles 2015/11/20 | Source: SimpleTalk | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 4,034 reads

SQL Prompt Tips #6 - Insert Semicolons

A quick SQL Prompt tip to automatically add semicolons to your code.  Read more...
By Steve Jones 2015/11/18 (first published: 2015/01/20) | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 4,303 reads

SQL Prompt Tips #5 - Current Statement Execution

Learn how a new feature in SQL Prompt 6.4 can help you avoid costly mistakes in coding.  Read more...
By Steve Jones 2015/11/11 (first published: 2015/01/12) | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 3,287 reads

SQL Prompt Tips #4 - System Objects

A quick tip to help you get system object suggestions from SQL Prompt.  Read more...
By Steve Jones 2015/11/04 (first published: 2012/05/01) | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,164 reads

SQL Prompt Tips #3 - Snippet Placeholder $Paste$

Another quick tip for SQL Prompt, using the snippets to increase your productivity.  Read more...
By Steve Jones 2015/10/28 (first published: 2012/05/01) | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,287 reads

SQL Prompt Tips #2 - Casing Options

A quick tip to help you set your object names to your preferred case in T-SQL code.  Read more...
By Steve Jones 2015/10/21 (first published: 2012/05/01) | Source: SQLServerCentral.com | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,586 reads
   Items 1 to 20 of 32    Older >>
 
Tags
redgate (10)    
formatting (5)    
quick tips (4)    
redgate software (2)    
blogs (1)    
delete (1)    
execution warnings (1)    
product reviews (1)    
snippets (1)    
sql (1)    
survey (1)    
templates (1)    
update (1)    
where (1)