SQL Server Archives - Page 420 of 420 - SQL Authority with Pinal Dave

SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure

January 30, 2007

SQL Server, SQL Server Management Studio, SQL Shortcut, SQL Stored Procedure

A quick Query Analyzer shortcut: map sp_helptext to a key, select any SP name and display the text of Stored Procedure right in the result window.

A baguette resting in a slotted wooden slicing guide, a few slices cut and the long uncut end beside a red cloth.

SQRT: Keep Fractional Roots in the Result

January 20, 2007

Pinal Dave

SQL Tips and Tricks

SQL Datatype, SQL Function, SQL NULL, SQL Server

SQRT produces an approximate square root. These read-only examples preserve fractional roots, state the display precision and distinguish a missing input from zero.

Card file of index cards, going through records one at a time like a cursor

SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created

November 30, 2006

Pinal Dave

SQL Tips and Tricks

SQL Cursor, SQL DateTime, SQL Scripts, SQL Server, SQL Stored Procedure

A simple cursor to select tables in a database by a static prefix like b_ or delete_ and by date created, so you can drop, print or index old tables.