Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You want to use the appropriate function to convert a binary value to the datetime2 data type. The conversion should not return a null value if this is not possible.
Which of the following built-in functions can you use to accomplish this goal?
on 11/30/2012 | Category:
Sql Server Interview questions
| Views: 2123 |
Select from following answers:
CONVERT enables you to convert data stored in one data type, such as binary, to another, such as datetime2. The conversion might fail if you attempt to convert between data types where conversion is not possible.
TRY_CONVERT enables you to attempt to convert data stored in one data type to another. If this conversion fails, a NULL value is written.
Show Correct Answer
Microsoft press book | |
< Previous :
You are optimizing several Transact-SQL statements ...
Next > :
The Employee table of the AdventureWorks2012 datab ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
The Employee table of the AdventureWorks2012 database includes informa ...
You want to remove the Odometer column of the Hovercraft table. This t ...
Recently, systems administrators scaled a web application you designed ...
You recently deployed an ASP.NET web application. Although the applica ...
You are designing a web application that will be deployed across ten s ...
You are creating a view for an MVC application. You need to create a n ...
You are creating a new web application. You must meet these requiremen ...
Latest Interview Questions
You have a Transaction table which is very important table because it ...
Write a C# sharp Program to check wheather the given string is Palindr ...
Which namespace will you use to get the value of connection string def ...
Write a C# program that prints the Prime numbers between 1 and 100 and ...
There is a PDF file which contains "GuideLines" in particul ...
Write a program in C# using Linq that prints count of leap years in 20 ...
Explain how do you differentiate between design pattern and framework ...
What is a design Pattern?