Ars Technica

TSQL: Using data from main query inside a sub query... do I need a temp table?

Let's say (for the sake of argument) that I want to find all the employees who quit working for my company AND what their most recent project was before they quit.<BR><BR>So I have tblEmployeesWhoQuit ...
Ars Technica

[SQL] Handle SELECT INTO #TempTable In IF/ELSE Statement

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...
TechRepublic

See performance gains by using indexed views in SQL Server

See performance gains by using indexed views in SQL Server Your email has been sent A view is a saved T-SQL query in SQL Server. The view definition is stored by SQL Server so that it can be used as a ...
Visual Studio Magazine

Working with JSON in SQL Queries

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...