Just Learned - $ is equal to zero

Getting Started with Adobe After Effects - Part 6: Motion Blur

A collection of quick technology learning tips from what people around you learn every day

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

$ is equal to zero

Jun 15 2011 8:57AM by Madhivanan

Run this and see the output

select $

Read More.. [0 clicks]

Published under: SQL Server Tips · · · ·

Madhivanan

3 · 39% · 12419

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it

Looks like $ indicating its money datatype. and an empty value is printing as 0.00.

commented on Jun 15 2011 9:47AM

Ramireddy

2 · 41% · 12972

it is money type

SELECT cast(sqlvariantproperty($,'BaseType') as varchar(20))

commented on Jun 16 2011 2:09AM

Divyang Panchasara

1911 · 0% · 9

I saw this trick to find the datatype previously..But i forgot this..

Thank you...

commented on Jun 16 2011 2:15AM

Ramireddy

2 · 41% · 12972

Sign Up or Login to post a comment.

"$ is equal to zero" rated 5 out of 5 by 11 readers +Madhivanan