I am researching SQL Server. Those who are asking me questions about SQL Server 2008, please refer following link. I will post my tutorials and articles very soon. Books Online is commonly known as BOL.
SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID()
NEWSEQUENTIALID() and NEWID() both generates the GUID of datatype of uniqueidentifier. NEWID() generates the GUID in random order whereas NEWSEQUENTIALID() generates the GUID in sequential order. Let us see example first demonstrating both of the function. USE AdventureWorks; GO ----Create Test Table for with default columns values CREATE TABLE TestTable…
Read MoreSQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
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…
Read MoreSQLAuthority News – Book Review – Learning SQL on SQL Server 2005 (Learning)
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…
Read MoreSQL SERVER – What is SQL? How to pronounce SQL?
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)
Read MoreSQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details
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…
Read MoreSQL 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.
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…
Read MoreSQL SERVER – UDF – Validate Integer Function
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…
Read More
SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
This post is second part of my previous post about SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days
SQL SERVER – 2005 – List All The Column With Specific Data Types
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).…
Read More