Different Data Types Available in SQL
If you’ve been reading here very long you’re probably aware that I’ve been teaching myself VB, .NET and SQL over the past couple of years.
One of my challenges of learning is that if I’m not using something regularly, I forget it or the information isn’t just sitting in the back of my head waiting for me to call it up. Now movie titles or songs and bands or other trivial information, that’s no problem. That stuff is immediately accessible for some reason.
Today I’m working on a SQL database table and I couldn’t remember the right data type option to use for one of the fields. I was thinking it was “binary” as I only needed the data to either be “Yes” or “No” represented by a 1 or 0. That wasn’t the right type though. What I actually needed to use was the “bit” datatype.
I found this page on the MSDN website and it’s got a nice list and description of all the datatypes available and what sets them apart from each other. Really nice resource so I figured I’d share.
msdn Transact-SQL Reference Data Types
Tags: binary, bit, data, data types, database, no, SQL, tables, yesRelated Stories
POSTED IN: Help and Support, MSDN, Microsoft Resources, Microsoft Tips & Tricks, Other Microsoft Sites, SQL Server, Training
0 opinions for Different Data Types Available in SQL
No one has left a comment yet. You know what this means, right? You could be first!
Have an opinion? Leave a comment: