I like to know the proper way to give credit to another answer or a source (bibliography). Especially when we used them indirectly.
When answering a question especially on Stack Overflow, we might have to study (research) other sources, questions, and answers which are not directly related to the question, but they might help us build our own answer. We might even have to learn a few things along the way.
Therefore, when answering, if we have learned & studied some stuff and used them indirectly to build our own answer or a part of the answer (learning the methods and use it in our own way to answer the question), should we give credit to those sources? If so, what is the proper way/format to do it in the Stack Exchange community?
For example, refer to this piece of code:
WITH cte AS ( SELECT column1, column2, column3, column4, columnN FROM table 𝗨𝗡𝗣𝗜𝗩𝗢𝗧 ( 𝗰𝗼𝗹𝘂𝗺𝗻𝟮 𝗙𝗢𝗥 𝗰𝗼𝗹𝘂𝗺𝗻𝗡𝗮𝗺𝗲𝘀 𝗜𝗡 (𝗰𝗼𝗹𝘂𝗺𝗻𝘀...) ) 𝘂𝗻𝗽𝘃𝘁 GROUP BY conditions... ) SELECT * FROM cte WHERE someconditions... ORDER someconditions...
If I write this code to answer a question on Stack Overflow, but some part (unpivot) were studied/learned from another question (not related to the original question), what is the proper way to give credit to those sources?
In some cases, we may have to refer many sources just to learn a new method. In these situations, it might not even practical to give credits to all the sources. What should we do then?
Note: References and bibliographies are different. According to Massey University article,
Reference lists contain a complete list of all the sources (books, journal articles, websites, etc.) that you have cited directly in a document. That means that if there are in-text citations for a source there is a reference list entry, and vice versa.
Bibliographies, on the other hand, contain all sources that you have used, whether they are directly cited or not. A bibliography includes sources that you have used to generate ideas or ‘read around’ a topic, but have not referred to directly in the body of the document.