Posts by Enio Lacerda • 87 points
3 posts
-
1
votes1
answer116
viewsQ: SQL Value Rounding in the PRINT command
good afternoon. An Internet exercise asks to calculate how long a given investment can pay a debt, both growing at an interest rate per month. Observe the created process declare @divida real =…
stored-proceduresasked Enio Lacerda 87 -
1
votes2
answers71
viewsQ: Passing value of a VARCHAR variable in the WHERE IN command
good night. I have the following example process CREATE PROCEDURE sp_listaFuncionarios @nome_dept varchar(50) as SELECT * FROM Funcionarios WHERE nome_departamento IN (@nome_dept) If during the…
-
6
votes4
answers268
viewsQ: BETWEEN demands arguments in ascending order? Why?
I have the following dummy table. I created the following query: SELECT * FROM ALUNOS WHERE IDADE BETWEEN 10 AND 15 Students A, C and D return. Now, because when I invert the order in the BETWEEN…