To accomplish a certain task, I count the amount of time I spend on the task in my system.
Today I came across the following:
Data Inicial: 17/12/2018 16:49:14
Data Final: 19/12/2018 08:02:58
totalizando: 2362,29 minutos.
Converto para d...
I created a trigger to report the fine on the return delay of rented movies, however, when triggering the trigger once (giving an UPDATE), the "MultaTotal" field does not update (only it). But when the trigger is triggered a second time, the fie...
Is it possible to create a temporary table that is mirrored in another?
Example: Let's say I have in my bank a table with 60 fields. I would like to create a temp named #tabela with the same structure as the table in the database, but wit...
Good morning guys,
I would like to know if it is possible to list all the comments in my "table" in SQL-SERVER, not column comments, but only the "tables"
I have a problem and I will try to explain the situation.
I have a client table called ENTIDADES , in it there is an attribute called ID_GRUPOECONOMICO where this is a FK of the GRUPOECONOMICO table. I am creating a...
I'm trying on my service to create temporary tables as I've always learned by putting # in front of the name I want. But I do not know what happens when I create one, it puts a huge underscore and some random stuff after the name. For exa...
Through this question I felt the need to research and understand a little about the UPSERT . I was wondering what a blessed command this is? I never saw ..
I found some information but it is still not clear to me because there is no "basi...
Good morning, I'm here with a pretty big question.
I've been in this for a whole day and I still have not been able to resolve the situation.
I have a database in sql server and I need to display a buttons with the records of the description of...