May 9, 2016 at 8:36 pm
Comments posted to this topic are about the item Vardecimal
May 10, 2016 at 2:03 am
The correct answer is "there is no vardecimal datatype".
It is not a different data type, it is a different way of physically storing the decimal data type.
It's also deprecated in SQL2016...
May 10, 2016 at 2:44 am
I agree - it is the very first statement of the explanation!
May 10, 2016 at 2:47 am
Agree, seeing the correct answer to the question, I think the question should have been "In SQL Server 2014, how do I use the vardecimal storage option?".
May 10, 2016 at 4:25 am
VARDECIMAL is a storage format, not a datatype...
pls my point..
May 10, 2016 at 6:48 am
Louis Hillebrand (5/10/2016)
VARDECIMAL is a storage format, not a datatype...pls my point..
You just got your point....now if they were only worth something.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 10, 2016 at 7:34 am
As others have pointed out, there is no spoon (with spoon being the fictitious vardecimal data type, of course).
I thought going that route seemed a bit easy, but oh well, crystal ball wasn't working yet 🙂
Still, I couldn't remember offhand whether this was still an option in 2014, so I at least got to confirm that.
Cheers!
May 10, 2016 at 7:48 am
Fine, just relax. Today's question is probably meant as a joke of the day 🙂
May 10, 2016 at 7:55 am
Also, in the article about the stored proc sp_db_vardecimal_storage_format it says it does not have to be enabled:
Starting with SQL Server 2008, user databases are always enabled. Enabling databases for the vardecimal storage format is only necessary in SQL Server 2005.
I checked and it's already enabled for my server on 2008 R2. (That's why I didn't pick the "correct" option)
May 10, 2016 at 8:39 am
The "not a data type" did seem like a simple route, albeit the correct one. Thanks, Steve.
May 10, 2016 at 8:45 am
I found it very interesting reading up on Vardecimal. The systems that I typically use rarely use decimal, much less a large number of such fields that could benefit from enabling this feature, so I've never used it. I wonder why it was removed from '16, possibly it wasn't being used very much?
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
May 10, 2016 at 9:45 am
I too learned something about variable length decimal option.
But I still feel cheated on being denied a bragging point. There is nothing wrong with saying there is no such thing as a vardecimal type.
May 10, 2016 at 10:01 am
j-1064772 (5/10/2016)
I too learned something about variable length decimal option.But I still feel cheated on being denied a bragging point. There is nothing wrong with saying there is no such thing as a vardecimal type.
Woohoo!!!! Since you posted a comment, you have been awarded 1 bragging point that you were cheated. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 10, 2016 at 10:10 am
Sean Lange (5/10/2016)
j-1064772 (5/10/2016)
I too learned something about variable length decimal option.But I still feel cheated on being denied a bragging point. There is nothing wrong with saying there is no such thing as a vardecimal type.
Woohoo!!!! Since you posted a comment, you have been awarded 1 bragging point that you were cheated. 😀
😎
May 10, 2016 at 10:22 am
Wayne West (5/10/2016)
I found it very interesting reading up on Vardecimal. The systems that I typically use rarely use decimal, much less a large number of such fields that could benefit from enabling this feature, so I've never used it. I wonder why it was removed from '16, possibly it wasn't being used very much?
I hadn't seen anything about that yet. Is it actually removed?
I thought it was still just deprecated. The documentation seems to support that (although goodness knows trusting MS documentation is a lottery).
Cheers!
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply