Posts by Fernando Schilipack • 13 points
3 posts
-
0
votes1
answer449
viewsA: How to run an INSERT Procedure with the GETDATE field? SQL Server
I managed to solve, I put in place the Dt_inclusion in the Process GETDATE this way BEGIN INSERT INTO TbCADLogin (ID, Usuario, Senha, Nome, Email, Telefone, Dt_inclusao, Dt_alteracao) VALUES (@ID,…
-
0
votes1
answer449
viewsQ: How to run an INSERT Procedure with the GETDATE field? SQL Server
Next, I created a precedent that has two parameters Dt_inclusion and Dt_alteration, I would like to know how to insert(or if it is possible to use) a getdate to pick up the current date, instead of…
-
0
votes1
answer786
viewsQ: How to join these two selects of the same table in SQL server?
Next, I need the amount per month of each customer who entered the year managed to do this, however I want q be shown in only 1 result. How do I join the two SELECTS? In order that it is added to…