databases

Technical Article

RE: Convert varchar to numeric

  • Reply

QUOTE: Not all the numbers are integers UNQUOTE. What else can numbers be? Yes Varchar to decimal is allowed. BUT! It must be ONLY numbers. No commas, no decimal points. This can be converted to decimal: 1234 These cannot be converted: 1.234 1,234 -SQLBill

You rated this post out of 5. Change rating

2003-07-29

Technical Article

RE: Overall Scorecard ?

  • Reply

Hi there, as of this morning, a comparison between the rest and me is up. ...but I tell you, it is massively frustrating to see that I scored only 52 points compared to 52,104 which the other members scored Now being serious, I think a comparison on absolute numbers is not appropriate here. just my […]

You rated this post out of 5. Change rating

2003-07-17

Technical Article

RE: poor Question of the day 7_13_2003

  • Reply

quote: - In normal conversation, we don't talk about what rights the guest user has in master and msdb and tempdb when we're talking about what rights a particular login has ... Therefore, this login that I'm using has no explicit rights assigned to it. Again, it's really all wrapped up in the semantics. But […]

You rated this post out of 5. Change rating

2003-07-14

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers