top of page
Search
Answer to the SQL Server Challenge
Our presentation booth at the Data Platform conference included an SQL Server challenge. Many people participated in trying to solve the question that was presented to them: What would be the result of running the following batch on SQL Server 2008? Transact-SQL CREATE TABLE #T (C INT); INSERT INTO #T (C) SELECT TOP (10) ROW_NUMBER () OVER (ORDER BY object_id ASC) FROM sys.objects; DECLARE @Command AS NVARCHAR(MAX) = N'SELECT C FROM #T WHERE C <= 5; TRUNCATE TABLE #T;'; INSE
bottom of page