Viewing 15 posts - 841 through 855 (of 1,048 total)
Eugene,
i tried this it select $ returns 0.00
while when i tried with other sumbols (!@#$%^&*_+) all returns an error..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 11:58 pm
when you run query for:
select convert(float,'-0')
it runs successfully
while if we put any other sign in SELECT CONVERT(INT,'.') other than '+/-' it will gives the same error as float will...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 8:10 am
yes,
SELECT CAST('1D2' AS FLOAT);
when I ran this query it ran successfully and gives 100 in output.. I dont know how it cast it to 100 :w00t:
While when I ran...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 8:00 am
i was just playing with CONVERT and faced this issue so just want to know about this weird behavior of float and INT in convert...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 7:49 am
tricky question
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 2:35 am
good points ny cliff and Bob...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 2:17 am
can anyone give the answer of Loner..
I am also confused on this now.. wch one is correct
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 2:04 am
whts this.. :w00t:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 2:02 am
good one Adam 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 1:57 am
Good question
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 1:56 am
David,
select ISNUMERIC(@value1+'.')
it also gives error:
Error converting data type varchar to float.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 1:56 am
very easy one...:-):-P
multiple getdate statement just to make question tricky
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 6, 2012 at 1:47 am
good one Carlo
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 5, 2012 at 5:09 am
whats question is this... 😎
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 5, 2012 at 4:58 am
good point Adams it should mentioned clearly in question but as in second data is was mentioned 1/31/2005 so it makes clear that format is mm/dd/yyyy 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 5, 2012 at 4:52 am
Viewing 15 posts - 841 through 855 (of 1,048 total)