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

SQLAuthority News – Advantages of Distance Learning

June 2, 2013

Distance education is extremely popular – almost overnight, it seems. Almost everyone has taken an online course, or knows someone who has, or is considering joining an online school. There are many advantages and disadvantages to attending an online school – but the same can be said of attending a…

SQL SERVER – Weekly Series – Memory Lane – #031

June 1, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQLAuthority News – New Theme of SQLAuthority and Video Courses

May 31, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

I have been blogging for almost 7 years now. Recently I reached a very important milestone for my blog. I completed over 2500 blog posts as well have been receiving consistently over 2 Million Views every month. It has been a fantastic ride and I am planning to continue contributing…

SQL SERVER – Add Identity Column to Table Based on Order of Another Column

May 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity

After reading my earlier article on Identity Column, I received a very interesting question. The reason, I like to call it interesting is though, I have provided answers to him, I believe there should be another better alternative to this problem. Let us see the question first in his own…

SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052

May 29, 2013

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL Identity, SQL in Sixty Seconds, SQL Scripts

Earlier I have posted a puzzle where I was receiving different results when I executed two different queries. I encourage all of you to read the original puzzle here, the puzzle had received many fantastic responses and I have later blogged about the solution of the puzzle over here. Now I…

SQL SERVER- Solution – SQL Puzzle of SET ANSI_NULL

May 28, 2013

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

Earlier I have posted a puzzle which received so many valid responses and got a fantastic explanation to the questions as well. I encourage all of you to read the original puzzle here. First run following script: SET ANSI_NULLS ON; -- Query1 SELECT 'SQLAuthority' AS Statement11 WHERE 'Authority' IN ('S','Q',…

SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods

May 27, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

Here is a very common question which I keep on receiving on my facebook page as well on twitter. “How do I insert the results of the stored procedure in my table?” This question has two fold answers – 1) When the table is already created and 2) When the…