July 19, 2007 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files

July 19, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security

Many times I have been asked how to change the result window from Text to Grid and vice versa. There are three different ways to do it. Method 1 : Key-Board Short Cut Results to Text – CTRL + T Results to Grid – CTRL + D Results to File…

SQL SERVER – SPACE Function Example

July 19, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

A month ago, I wrote about SQL SERVER – TRIM() Function – UDF TRIM() . I was asked in comment if SQL Server has space function? Yes. SELECT SPACE(100) will generate 100 space characters. The use of SPACE() function is demonstrated in BOL very fine. Example from BOL: USE AdventureWorks;…