Viewing 9 posts - 61 through 69 (of 69 total)
I just tried the following and didn't get the results I thought I could:
select cast(convert(money,'2,199.8352') as float)
result: 2199.8352 (this is good)
select cast(convert(money,'2.199,8352') as float)
result:Server: Msg 235, Level 16, State 1,...
April 5, 2005 at 7:53 am
I thought of doing that but the precision only goes out to 4 decimal places. There is a possibility of more.
April 5, 2005 at 7:02 am
It's pretty obscure but I was actually having this problem in an application I was working on.... it was giving me a 644 error and I found this article on...
March 31, 2005 at 7:45 am
Ahhhh....that makes sense now.
Hopefully SP4 will be out of beta soon and the 'problem' with unicode will be completely resolved.
March 31, 2005 at 7:00 am
This is more of an exercise for me to see how much impact unneccessary indexing has on the larger tables....not so much what I will be practicing in the production environment. ...
March 22, 2005 at 8:53 am
Yeah I noticed that....the script that I am running is for maintenance only and not for any kind of oltp actions so I should be okay in that respect.
Essentially...
March 22, 2005 at 7:13 am
Awesome. This is exactly what I was looking for. Thanks.
March 21, 2005 at 2:16 pm
I was looping through all columns in all tables using the 'sysobjects' and 'syscolumns' tables to run a basic selectivity query to determine which columns should be indexed or not.
That...
March 21, 2005 at 8:08 am
Viewing 9 posts - 61 through 69 (of 69 total)