Jeff,

What do you mean when you say doing vertical alignment.  I noticed you also mentioned that in your past last night.

Phil,

I tested the SUM aggregate function on TINYINT and it works great.  Thank you.

Jeff Moden,

I didn't know you could create an alias like:  [Contract Number] = ContractNo

Good to know.   And thank you for all of your feedback.

On that same note, I'd also change the datatype for "IsBillable" and "IsActive" to TINYINT and use a 1 for "Yes" and a 0 for "No" along with constraints...

• This reply was modified 5 years, 7 months ago by  michael.leach2015.

Last but certainly not least, there is no way that I'd ever include spaces or other special characters in the columns so as to make them require brackets.

You're also...

It was the commas I had before the keyword DEFAULT.  I was in the mindset of separating things with commas which is why I did that.  Thank you.

I tried this and I'm still getting the same error.  I also tried using double quotes around the default values instead of single quotes and that didn't work.  Also if...

• This reply was modified 5 years, 7 months ago by  michael.leach2015.
• This reply was modified 5 years, 7 months ago by  michael.leach2015.

I never would have guessed that.

This website indicates that parenthesis are not required:

https://www.w3schools.com/sql/sql_default.asp

And the SQL online documentation doesn't seem to indicate that parenthesis are required either (see the...

Thank you.  This helps.  I'm new into this stuff.

Great.  Thank yoou.

Ok, I ran a query against "sys.databases" using suser_sname ( ) and got the name of the db owner.  Recently I changed the name of my computer to a name...

• This reply was modified 5 years, 9 months ago by  michael.leach2015.
• This reply was modified 5 years, 9 months ago by  michael.leach2015.

Thank you for the links you sent me.  I looked at those which led to one link after another.  Eventually I was reading about system views, system tables, etc. which...

Ok.  Good point.  And good advice.  I tried DATALENGTH on a:

tinyint variable assigned the value of 1

smallint variable assigned the value of 1

int variable assigned the value of 1

bigint variable...

If the database diagrams are deprecated how else would it be possible to see the connections/joins between various tables?  Surely there is a way to see how all tables are...

I tried again and now I get the message "Incorrect syntax near '\'

Any suggestions?