Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What will be the output of below Sql-server query?
SELECT CAST(CAST(205.45 AS varbinary(20)) AS decimal(10,5));
on 12/20/2013 | Category:
Sql Server Interview questions
| Views: 3384 |
Select from following answers:
None of these.
Output will be 205.45000.
As we have cast 205.45 to decimal(10,5),means it will be be treated as 5 decimal places,so after decimal point it will be 5 decimal places,so 205.45 will be 205.45000
Show Correct Answer
Many Interviews |
< Previous :
How to check whether Connection is Open or not?
Next > :
How to Remove particular column from DataTable at ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
How to Remove particular column from DataTable at specified Index posi ...
How to add columns in DataTable?
What is the output of below C# code? string str = null; str = Conv ...
What is the output of below C# code? string str = null; str = str. ...
How to Insert any Item inside List at specified position?
Latest Interview Questions
Your developing web application which access data from a MS sql and ha ...
Differences between ISNULL and NULLIF ?
What will be output of following function when called? public strin ...
DB2 - Display the employee details who are working from more than 1 an ...
DB2 - Fetch the current date and time in the following format 24/APR ...
DB2 - Find the NAMEs that have an even number of letters in them
DB2 - Find the count of departments having average salary greater than ...