thava (4/25/2014)

---

how about this one

DECLARE @test-2 AS TABLE (Code nvarchar (2),Amt numeric(18, 0))

INSERT INTO @test-2

VALUES

('09',1000), ('09',12000), ('09',1300), ('09',1400), ('09',1500),

('10',2000), ('10',2100), ('10',2200), ('10',2300), ('10',2400),...

My solution as follows.

SELECT 'Type' Type

, col1 = [09]

, col2 = [10]

...

+1

Interesting QOD. Learned today

good one

Thank you Hugo Kornelis and TomThomson for the explanation

But i really dont understand one thing, tablesample is expecting 4 rows to return, but the result set is totally different, that too on different execution, the purpose of the...

thanks tom for the detailed explanation

Thank you for the replies

My point is, for the given question it returns 5 rows, so answer is 5 🙂

when we are specifying high range of rows nearing to the exact no of rows then it will return all the rows of the table

like , in the QOD

we have...

For the given example it returns exactly 5 rows, tablesample option might give different output if the table has more no of rows. :unsure:

Please give column names in the insert statement

Like

SET IDENTITY_INSERT SecuritySettings ON

INSERT INTO SecuritySettings ( col1,col2,col3 etc.,)

SELECTSecuritySettingsId,

UserGroup,

SecurityNodesId,

Allowed,

SecurityType,

Created,

CreatedBy,

LastModified,

LastModifiedBy

FROM SecuritySettingsBAK;

did you increase the size of .mdf or .ldf ?

Thanks for the question.

You have given a hint in QOD to select one option out of 3.

The above hint tells that database and login...