|
|
|
|
-
Dattatrey Sindol (Datta) Liked 10 Months ago through Blogs
How do you extract Day of the Year, Day of the Week and Week Number values from a given date using nothing but T-SQL? In this post, we look at how the DATEPART function can be of help in achieving this requirement....
|
-
Dattatrey Sindol (Datta) Commented 10 Months ago through Blogs
Good one Nakul! But I see one problem with the Week related expression. Since DATEPART() depends on the value of @@DATEFIRST, so the value you get will vary depending on the value of @@DATEFIRST at the session level. Here is a more concrete way of doing...
|
|
|
|
|
-
commonly asked C# interview questions and answers...
|
-
Good to know this. Thanks for sharing Paras!...
|
-
Good to know this. Thanks for sharing Paras!...
|
-
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
-
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|