How to get the value of first day of the week?

Posted by Lakhangarg on 4/26/2010 | Category: Sql Server Interview questions | Views: 5519

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

using SELECT @@DATEFIRST we can get the value of first day of the week.
if it will return 1 then it means Monday is the first day but if it returns 7 then that means Sunday is the first day.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is Tabular Value Function ?

Next > : How we can specify the first day of the week?

Comments or Responses

More Interview Questions by Lakhangarg

How we can specify the first day of the week?
How to apply filter using BindingSouce?
How can we Move to Next and Previous Record using BindingSource Class
Can we insert a blank row using BindigSource Class?
How can we find the index of current selection in BindingSource Class?
AddNew() method of BindingSource Class will add a blank row or with so ...
Can we Add New Row into a Grid Using Binding Source?
Which Task in SSIS is used to perform operation on a file or directory ...

Latest Interview Questions

What is Delay Signing ?
What is GAC?
What is Sealed Class ?
What is a DependencyProperty and How to implement it?
Sorting on a Datatable
Can we have same method with same name and signature in a using partia ...
How can we Filter rows in a Datatable ?
Select * from table1,table2
More ...