Semiotics (also called semiotic studies) is the study of sign process (semiosis), which is any form of activity, conduct, or any process that involves signs, including the production of meaning. A sign is anything that communicates a meaning, that is not the sign itself, to the interpreter of the sign. The meaning can be intentional such as a word uttered with a specific meaning, or unintentional, such as a symptom being a sign of a particular medical condition. Signs can communicate through any of the senses, visual, auditory, tactile, olfactory, or taste. The semiotic tradition explores the study...
@CadeRoux Right, they actually wanted what you typed. I think it might have started out as Oracle code with FROM dual and they didn't realize they could remove the FROM clause in the SQL Server version. But that's just a guess.
Lol, no but I confuse myself sometimes coming back to read things when there is no table.
I had a similar funny construct that tripped me up yesterday so I had to add a huge comment for the future
FROM [AscendCV].dbo.[Study] src_Study
INNER JOIN [AscendCV].dbo.[StudyStatus] src_StudyStatus
ON src_StudyStatus.ID = 2 -- ALL Studies have a start - there is no join to study's current state
It's just a cross-join to generate a start for all studies, and to be able to pull the Label column for starts from the Status table.
I agree it's a little misleading. Although it would be an entirely different story if it was a left join and you needed to guarantee at least one row. Can't think of a practical example where that would be needed but still
You can create an enumeration type in SQL Server using a XML Schema.
For example Colors.
create xml schema collection ColorsEnum as '
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="Color">
<xs:simpleType>
<xs:restriction base="xs:string">
...
@Philᵀᴹ the Bye Felecia hat, which you get if if you disagree with the CoC to the extent that you get suspended, or lose your diamond/moderator privileges; and/or, you otherwise out yourself as a transphobe.
We implemented CLR parsing for our xml processing as we had large documents (service broker message) and the native methods forced use to walk the tree multiple times. We implemented a one pass message using C#
Right now I am confused with the fact that I have 237 points or reputations I am seeing at the top right of the Database Administrators forum, but in YOUR COMMUNITIES list it says 172.
@MaxVernon You're a pretty security-minded guy. I just had someone tell me that I should turn off the reading pane in Outlook because it's a security risk. That hasn't been true for a long time, right?