analyze the following code snippet declare mydate datetime2 select 2009 10..., Knowledge of SQL Server 2008, .Net Technology

Knowledge of SQL Server 2008

Test
- Model Test
Index

Question:Analyze the following code snippet:

DECLARE @myDate DATETIME2
SELECT @myDate = '2009/10/08 12:35:29.2348 +12:15'
SELECT @myDate AS '@myDate'

What is the output of the above code?

A 2009-10-08 12:35:29 
B 2009/10/08 12:35:29.2348000 
C 2009-10-08 12:35:29.2348000 
D 2009/10/08 12:35:29

/102

+ AnswerC

+ Report

Descriptive on Knowledge of SQL Server 2008 Ebook

Total Preview: 394

Question:Analyze the following code snippet: DECLARE @myDate DATETIME2 SELECT @myDate = '2009/10/08 12:35:29.2348 +12:15' SELECT @myDate AS '@myDate' What is the output of the above code?

A 2009-10-08 12:35:29

B 2009/10/08 12:35:29.2348000

C 2009-10-08 12:35:29.2348000

D 2009/10/08 12:35:29

C