analyze the following code which uses top clause of sql server 2008..., Knowledge of SQL Server 2008, .Net Technology

Knowledge of SQL Server 2008

Test
- Model Test
Index

Question:Analyze the following code which uses the TOP clause of SQL Server 2008:USE Person
GO
DECLARE @p AS int
SELECT @p=10
SELECT TOP(@p)
FROM Employee
GO
What Will be the output of the above code?

A No output is displayed. 
B A list of first 10 employees is displayed from the Person database. 
C An incorrect syntax error is displayed. 
D None of these.

/102

+ AnswerC

+ Report

Descriptive on Knowledge of SQL Server 2008 Ebook

Total Preview: 448

Question:Analyze the following code which uses the TOP clause of SQL Server 2008:USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO What Will be the output of the above code?

A No output is displayed.

B A list of first 10 employees is displayed from the Person database.

C An incorrect syntax error is displayed.

D None of these.

C

Question:Analyze the following code which uses the TOP clause of SQL Server 2008:
USE Person GO DECLARE @p AS int SELECT @p=10 SELECT TOP(@p) FROM Employee GO
What Will be the output of the above code?