SQL Archives - Page 487 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

August 15, 2007

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

Following three questions are many times asked on this blog. How to insert data from one table to another table efficiently? How to insert data from one table using where condition to another table? How can I stop using cursor to move data from one table to another table? There…

SQLAuthority News – Book Review – Learning SQL on SQL Server 2005 (Learning)

August 14, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQLAuthority Book Review

SQLAuthority.com Book Review : Learning SQL on SQL Server 2005 (Learning) [ILLUSTRATED] (Paperback) by Sikha Bagui, Richard Earp Link to book on Amazon Short Review: This books covers simple and complex concept in very easy language with lots of examples. Every beginner can learn a great amount of tips from…

SQL SERVER – What is SQL? How to pronounce SQL?

August 14, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA

SQL is abbreviation of Structured Query Language. SQL is pronounced as S.Q.L. (ess-que-ell or ess-cue-ell) not sequel. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details

August 13, 2007

Pinal Dave

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

DBA, SQL Backup and Restore, SQL Index, SQLAuthority Author Visit

Last weekend I visited New York City (NY) and Edison (NJ) to attend database architecture meeting with a big environmental technology firm. It was very interesting to meet CEO and few of the lead database administrators. Lots of database related things were discussed. I will list few of the points…

SQL SERVER – Fix : ERROR : Msg 1033, Level 15, State 1 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

August 12, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

Following error is encountered when view is attempted to created with ORDER BY clause in it. ORDER BY clause is not allowed in views in SQL Server 2005. This solution also displays the workaround to use ORDER BY in VIEW. I really do not prefer to use views. My views…

SQL SERVER – UDF – Validate Integer Function

August 11, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

I received quite a good feedback about my post about SQL SERVER – Validate Field For DATE datatype using function ISDATE() One of the most interesting comment I received from my reader from Canada. I was suggested just like ISDATE() to write about ISNUMERIC() which can be used to validate…

SQL SERVER – 2005 – List All The Column With Specific Data Types

August 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Datatype, SQL Scripts, SQL System Table

Since we upgraded to SQL Server 2005 from SQL Server 2000, we have used following script to find out columns with specific datatypes many times. It is very handy small script. SQL Server 2005 has new datatype of VARCHAR(MAX), we decided to change all our TEXT datatype columns to VARCHAR(MAX).…