kapil_kk

Forum Replies Created

Viewing 15 posts - 676 through 690 (of 1,048 total)

RE: Precision required

Richard Warr (3/14/2013)
Hugo Kornelis (3/14/2013)
Richard Warr (3/14/2013)
What do I have that is different (I'm in the UK if that helps)?
Locale settings.
Contrary to popular belief, yyyy-mm-dd hh:mm:ss and yyyy-mm-dd are NOT...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 14, 2013 at 6:10 am

#1596947
RE: Precision required

easy +1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 13, 2013 at 11:10 pm

#1596821
RE: Temp Table Data Types

Stewart "Arturius" Campbell (3/13/2013)
Interesting question, thanks Dave
Another way to check the detail of the temp table would be to execute tempdb..sp_help #TempQoD
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 13, 2013 at 4:05 am

#1596406
RE: Temp Table Data Types

Raghavendra Mudugal (3/13/2013)
Stewart "Arturius" Campbell (3/13/2013)
Interesting question, thanks Dave
Another way to check the detail of the temp table would be to execute tempdb..sp_help #TempQoD
Now this is very very new thing...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 13, 2013 at 4:04 am

#1596405
RE: INNER JOIN

Lokesh Vij (3/12/2013)
kapil_kk (3/12/2013)
yes, I learned different new things from the feedback and interaction of the people......
That's the spirit Kapil. This happens with every one when you post your first...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 12, 2013 at 10:10 am

#1596112
RE: INNER JOIN

Hugo Kornelis (3/12/2013)
The idea of this question is nice, but the execution is poor (i.e. "correct" answer is not correct) and the explanation is simply incorrect.
As others have said, the...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 12, 2013 at 9:12 am

#1596078
RE: INNER JOIN

thanks,
Yes, I will keep posting more new questions as its just a start for the way to MVP :-):-P
Thanks to all for your support
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 12, 2013 at 8:55 am

#1596064
RE: INNER JOIN

yes, I learned different new things from the feedback and interaction of the people......
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 12, 2013 at 8:53 am

#1596063
RE: INNER JOIN

Hi all,
Actually I read an article with a name Difference between Datetime and Datetime2 and surprised with the functioning of that so then I think of implementing that thing...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 12, 2013 at 6:56 am

#1595967
RE: DATETIME - 3

thanks for the explanation....
Previously I didn't check the link.. after reading explanation I check that link and read that fully and its clear my doubts..
Thanks Ron for the question that...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 11, 2013 at 2:35 am

#1595412
RE: DATETIME - 3

Hi,
can someone plz explain it in a more simple manner..... explanation in QOTD is very inscrutable for me:cool:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 11, 2013 at 12:57 am

#1595403
RE: SubQuery

oopes...
marked wrong answer today :w00t:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 8, 2013 at 5:31 am

#1594925
RE: CREATE statement

GOOD QUESTION...
NICE EXPLANATION FROM GUYS lOKESH, DANNY... 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 7, 2013 at 7:09 am

#1594431
RE: ISNUMERIC

lots of people have issues with Header of the QOD 😎
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 6, 2013 at 7:24 am

#1593947
RE: ISNUMERIC

good basic question to start the day....
In first line I saw that its only varchar to length would be 1 only and 3 is present in text so quickly mark...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

March 5, 2013 at 10:40 pm

#1593763

Viewing 15 posts - 676 through 690 (of 1,048 total)