I work for a company where for decades the first rule of computing seems to have been 'Defense of the system is more important than its use' which has resulted...

Hugo Kornelis (11/23/2015)

---

Iulian -207023 (11/23/2015)

---

Is there a naming convention that you can recommend ?

i.e. for user tables tbl_

for user's views vw_

for user's functions f_

for procedures p_

or something like this...

sipas (11/4/2015)

---

Carlo Romagnano (11/4/2015)

---

If I want to be pedant, the right answer is "All of the above".

Because of lacking of batch separator "GO".

If you run the script no procedure is...

I answered All of the Above because I understood it to be about practices, not syntax. I agree with others that bad syntax will be avoided because it won't...

Actually on my system the answer is an error because the table would be created in my personal schema but then the insert and select are from dbo. Converting...

Stephanie Giovannini (10/27/2015)

---

The Messages pane gives some insight. Without GO statements, this is one SQL batch. The connect commands are processed in order before any of the SQL is executed.

Connecting...

I am completely baffled by being able to get a result for Server2 before it has even been connected to. Can somebody give a better explanation? The one...

The convention for the group I came into when learning SQL Server is *_is_active_indicator which makes for some very long names for some very short columns

sipas (8/14/2015)

---

Do models contain the values of entities? I thought the model contained entities, as in their attributes and hierarchies, but the attribute values are in the entity rather than...

Toreador (8/5/2015)

---

Didn't even notice the position outside the While loop. The fact that the variable is set to 1 on the previous line means that even if it were within...

I had a situation where in older tables a column was named CNTRY_CODE due to column name length limitations at the time. When the name length restriction went away they...

As I read the documentation at

https://msdn.microsoft.com/en-us/library/ms181591(v=sql.110).aspx

and saw

ENCRYPTION = { DISABLED | { { SUPPORTED | REQUIRED }

[ ALGORITHM { RC4...

I thought the question was going to be how many rows are returned from each query. I would have picked 2, 1, 0, 2. However, I ran the...

Thank you again for the assistance and education. I will be more careful with my test data next time. The system locks up whenever I try to post...

Yes, intersect is not normal to me either. I actually changed it where exists and then used except. Still non-obvious logic for me so I am glad to...