Session variables are go
CREATE TABLE my_test_table(var INT DEFAULT 0);
INSERT INTO my_test_table VALUES (3);
CREATE PROCEDURE my_sp_test_function()
BEGIN
DECLARE localVar INT DEFAULT 1;
#SET @userVar = 1; ### If we swap this line for the one above the query works. ###
SELECT
...
Thunderbirds Are Go is a 1966 British science-fiction puppet film based on Thunderbirds, a Supermarionation television series created by Gerry and Sylvia Anderson and produced by their company Century 21 Productions. Written by the Andersons and directed by David Lane, Thunderbirds Are Go concerns spacecraft Zero-X and its human mission to Mars. When Zero-X suffers a malfunction during re-entry, it is up to life-saving organisation International Rescue, supported by its technologically-advanced Thunderbird machines, to activate the trapped crew's escape pod before the spacecraft hits the ground...
Tyrian purple (Ancient Greek: πορφύρα porphúra; Latin: purpura), also known as Phoenician red, Phoenician purple, royal purple, imperial purple, or imperial dye, is a reddish-purple natural dye; the name Tyrian refers to Tyre, Lebanon. It is a secretion produced by several species of predatory sea snails in the family Muricidae, rock snails originally known by the name 'Murex'. In ancient times, extracting this dye involved tens of thousands of snails and substantial labor, and as a result, the dye was highly valued. The main chemical is 6,6′-dibromoindigo.
== Background ==
Biological pigments...
16
For WITH SAMPLE 50 PERCENT it works as though for each data page in the table SQL Server flips a coin. If it lands heads then it reads all the rows on the page. If it lands tails then it reads none.
Tracing the UPDATE STATISTICS T WITH SAMPLE 50 PERCENT call in Profiler shows the following query...
