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 More