So we are doing document scanning and saving these TIF files in the database. I needed to determine how big the TIF files being imported actually were.
TSQL DATALENGTH function. It returns the value in bytes.
SELECT DATALENGTH(column1) FROM table1 WHERE ID1 = ‘VALUE’
Thanks for the help, @JimHolmes. (link)
We’re going to try it. Herch keeps writing down his ideas, some of which were actually mine about a year ago, and some of us will try play testing it tonight. I’ve never created a board game before. I’ve got a feeling I’ll be spending 50 bucks at Toys ‘R’ Us to buy some other games to cannabalize for game board and game pieces.
I did just receive my Rock Band 2 Ion Premium Drum Kit, and it needs to be assembled before I explode from anticipation, but it can wait until tomorrow if it means we have a new board game hit on our hands. But fairly soon I have to get down to the business of learning to play the drums. That’s not even counting what I need to learn for work (I’ve got basic scripting down, but many DBA activities still evade my understanding). Good thing I’ve got vacation time already planned.
What have we learned today? Well, these little gems have helped me out immensely today. I’m going to keep them handy for future use.
List all of the Tables in a Database
SELECT Name
FROM SYSOBJECTS
WHERE XTYPE=’U’
ORDER BY Name
List all of the Columns in a Table
SELECT Column_Name
FROM INFORMATION_SCHEMA.Columns
WHERE TABLE_NAME = ‘<Name>’
