Viewing 15 posts - 76 through 90 (of 146 total)
Jeff,
What do you mean when you say doing vertical alignment. I noticed you also mentioned that in your past last night.
July 25, 2019 at 1:36 am
Phil,
I tested the SUM aggregate function on TINYINT and it works great. Thank you.
July 25, 2019 at 1:28 am
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.
July 25, 2019 at 1:16 am
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...
July 24, 2019 at 3:49 am
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...
July 24, 2019 at 1:34 am
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.
July 24, 2019 at 1:10 am
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...
July 23, 2019 at 2:40 am
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...
July 23, 2019 at 2:36 am
Thank you. This helps. I'm new into this stuff.
July 3, 2019 at 11:53 pm
Great. Thank yoou.
July 3, 2019 at 11:52 pm
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...
May 27, 2019 at 6:21 pm
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...
May 25, 2019 at 5:11 am
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...
May 24, 2019 at 3:22 am
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...
May 22, 2019 at 4:27 am
I tried again and now I get the message "Incorrect syntax near '\'
Any suggestions?
May 22, 2019 at 4:25 am
Viewing 15 posts - 76 through 90 (of 146 total)