Viewing 15 posts - 4,366 through 4,380 (of 5,111 total)
What are you doing at the time it happens. Are you running a query, trying to connect to a specific instance?
January 27, 2017 at 4:26 am
you should also ensure that you provide your dates in a format that anyone can use. Your dates wouldn't work my end as there's not 13 months in the year.
January 27, 2017 at 2:31 am
int, bigint, smallint, and tinyint (Transact-SQL).
BIGINT (-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)) can store a much larger number than INT (-2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)) can, but uses double...
January 26, 2017 at 9:16 am
BWFC - Thursday, January 26, 2017 8:40 AMIt's better, but if CELKO catches you, don't say you weren't warned 😀
Eh, I do sometimes...
January 26, 2017 at 8:43 am
This is part of the reason why SQL is call an RDMS ( January 26, 2017 at 8:36 am
January 26, 2017 at 8:34 am
Your result is to be expected, as you're not defining any JOINs. SQL needs to now what records are related to what, otherwise it has no idea.
It this...
January 26, 2017 at 8:02 am
Out of interest, why would you want to store these in a table? If your data changes, this would mean that your table of student ID's would be stale, and...
January 26, 2017 at 6:01 am
Check your column's hidden settings. It will have a setting that has the cell you are clicking set to hide or show it.
January 26, 2017 at 5:36 am
January 26, 2017 at 2:37 am
Seeing the full query now means that there's a lot of places this could be falling over. Although I said start with the above columns, upon seeing the above, you...
January 25, 2017 at 9:44 am
January 25, 2017 at 9:08 am
The problem is that one of your columns contains a value that cannot be converted to a numeric. Your attempts above won't solve this (in this case stating a conversion...
January 25, 2017 at 8:48 am
Doh. it was me using an incorrect query. You are correct.
I was doing:
[code...
January 25, 2017 at 7:34 am
Viewing 15 posts - 4,366 through 4,380 (of 5,111 total)