|
|
-
Madhivanan Posted 4 Months ago through Blogs
You may need to often find the end of the month for various monthly analysis. In this case you need to take all data from 1st of month to end of month.
Consider the following set of data Create table #test(date_col datetime)
insert into #test(date_col)...
|
-
Madhivanan Commented 4 Months ago through Blogs
Right Click and make sure that **Intellisense Enabled** is enabled...
|
-
Madhivanan Commented 4 Months ago through Blogs
Are you sure you are using version 2008 and Intellisense is enabled? Also type SELECT and a space and then press CTRL+space bar. See if you get popup menu...
|
-
Madhivanan Commented 4 Months ago through Blogs
Bala Krishna, I have already told this to Jacob , I think the new blogger's posts are reviewed before published....
|
-
Madhivanan Commented 4 Months ago through Blogs
Bala krishna, Can you open a new session and try?...
|
-
Madhivanan Commented 4 Months ago through Blogs
Bala Krishna, Yes thats a good point to note. Thanks...
|
-
Madhivanan Commented 4 Months ago through Blogs
Thank you Bala Krishna for your feedback...
|
-
Madhivanan Commented 4 Months ago through Blogs
Thanks Balakrishna fro the feedback...
|
-
Madhivanan Liked 4 Months ago through Blogs
It seems often users want to check whether the data has only numbers in a varchar type column. The commonly suggested one is to make use of ISNUMERIC() function. But the problem in using that function is that it will treat some alphabets, $, char(10),et...
|
-
Madhivanan Commented 4 Months ago through Just Learned
Balakrishna, isnumeric is not fully reliable. It will aceept formatted number. Refer this post for more information http://beyondrelational.com/modules/2/blogs/70/posts/10803/enhanced-isnumeric-function.aspx...
|