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

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

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.