Posts by Douglas Vieira • 177 points
8 posts
-
0
votes0
answers33
viewsQ: What are Python commands with underscore at the beginning and end?
I realize that some scripts in Python have expressions with commands like this: __name__ == “__main__”' __str__,__repr__ self.__class__ self.__dict__ What are these commands that start and end with…
-
1
votes2
answers242
viewsQ: What is In[]: and Out[]:?
For some time I am writing some basic scripts with Python, in some tutorials sometimes I come across In []: and Out[], Usually equal values appear to the forehead. Below is a small example. In [24]:…
-
3
votes1
answer85
viewsQ: Is there a loop loop behind the code of a CTE?
I’m racking my brain to understand how such a simple command can generate values from 1 to 100. Is there a loop behind a CTE? For in the code below there is a loop WHERE and not a WHILE. WITH…
-
1
votes1
answer193
viewsA: How to read position information that Cursor is in SQL Server
To be able to read the Cursor without necessarily having to pass line by line, just use the command FETCH ABSOLUTE instead of FETCH NEXT,and then the number of the desired line, for example, to…
-
1
votes1
answer193
viewsQ: How to read position information that Cursor is in SQL Server
In the Cursor examples I found, to read the information I have to use the command: FETCH NEXT FROM In my code it’s like this: FETCH NEXT FROM CURSOR1 INTO @NAME - at the line Cursor is on I assign…
-
0
votes2
answers189
viewsQ: How to locate information by considering a range (range of numbers)
In the company where I work we are automating the process of calculating variable remuneration, and for this we are transposing all the logic that was in the EXCEL to the database. However, I’m…
-
9
votes2
answers132
viewsQ: How to correctly read documentation from an SQL command?
I was studying the concept of transactions and as always the reference was the documentation of Microsoft itself (in the case for the products of the same). In the link below there is the…
-
0
votes1
answer425
viewsQ: Is there a difference in performance between INNER JOIN and CROSS APPLY?
I am starting studies on SQL SERVER and some places teach to use the INNER JOIN to make the junction of two tables. However, there are some other places that teach via CROSS APPLY.…