Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What will be output of below query?
Select Month('01/23/2014') as 'Month';
on 1/23/2014 | Category:
Sql Server Interview questions
| Views: 713 |
Output will be 1,because Month in-built sql server function will extract only month part from any date.Here month is 01 i.e. Jan,so it will return 1.
Many Interviews |
< Previous :
What is the return type of Month in-built sql serv ...
Next > :
What is the use of Month in-built Sql-Server funct ...
Comments or Responses
Login to post response
More Interview Questions by Rajesh_Kumar
What is the use of Month in-built Sql-Server function?
How many joins are there in Sql-Server?
What are the types of Cursors?
What considerations must be there when working with Cursors?
How to remove leading space from below string? string name = " ...
How to remove white spaces or empty spaces from within String?
What are Cursors in Sql-Server?
What are the values that @@Fetch_Status Function return while dealing ...
Latest Interview Questions
Write a program using Linq to create a sequence that contains common f ...
What is the output of the following query? var query = from student ...
Which of the following statemet(s) is correct with respact to ArrayLis ...
Can we have different access modifiers for the get and set methods? Ju ...
Can you call a native function that is exported from a dll, if so how?
What is meant by satellite assembly?
How can you define Delay signing?
Is there a possibility to create multilanguage, multifile assembly? If ...