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

SQL – Download FREE Book – Data Access for HighlyScalable Solutions: Using SQL, NoSQL, and Polyglot Persistence

September 29, 2013

Big Data, SQL, SQL Server, SQL Tips and Tricks

Recently I was preparing for Big Data and I ended up on very interesting read for everybody. This is created by Microsoft and it is indeed a fantastic read as per my opinion. It took me some time to read this entire book but it was worth reading this as…

SQL SERVER – Select Columns from Stored Procedure Resultset

September 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

It is fun to go back to basics often. Here is the one classic question: “How to select columns from Stored Procedure Resultset?” Though Stored Procedure has been introduced many years ago, the question about retrieving columns from Stored Procedure is still very popular with beginners. Let us see the…

SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 3

September 24, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? and SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2. In part 2 of the blog post, I wanted to write…

SQL Contest – Hint for Identify the Database Celebrity

September 23, 2013

Pinal Dave

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

Earlier week I have posted a SQL Contest about Identifing the Database Celebrity over here Identify the Database Celebrity – Win USD 100 Amazon Gift Card. We have got fantastic response to the blog post however, there are quite many readers have requested Hint to the contest. In the world…

SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2

September 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?. Right after the blog post was published I received an email from SQL Server users who have no access to CTE and wanted me to help him out…

SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?

September 22, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

The first email I read this morning had only one statement in it, and it gave me an idea to write this blog post. “How to access Previous Row Value and Next Row Value in SELECT statement?” Very interesting question indeed. The matter of the fact, I have written about this…

SQL SERVER – UDF, UPDATE and More – Memory Lane – #047

September 21, 2013

Pinal Dave

SQL

Memory Lane, SQL Server

This is the 47th episode of 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. My favorite blog posts are about UDF and the difference between UPDATE and UPDATE (). Let me know which one of the following is your favorite article from memory lane.