Vardecimal
-
Comments posted to this topic are about the item Vardecimal
-
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...
-
I agree - it is the very first statement of the explanation!
-
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?".
-
VARDECIMAL is a storage format, not a datatype...
pls my point..
-
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/ -
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!
-
Fine, just relax. Today's question is probably meant as a joke of the day
-
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)
-
The "not a data type" did seem like a simple route, albeit the correct one. Thanks, Steve.
-
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] -
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.
-
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/ -
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.
-
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