Posts by Pedro Pereira • 21 points
2 posts
-
1
votes2
answers90
viewsA: How can I Create a column in SQL SERVER where, depending on the value, debt or credit appears?
I’ve got it, here’s the personal solution: ALTER TABLE dbo.Dados ADD [Debito/Credito] AS CASE WHEN [Valor em EUR] < 0 THEN 'Debito' ELSE 'Credito' END;
-
1
votes2
answers90
viewsQ: How can I Create a column in SQL SERVER where, depending on the value, debt or credit appears?
Good friends, I made a program where I import data from an excel file in the sql database, this database is about values, and etc... And wanted to know if you have how to create a column where after…