Posts by Wilton De Queiroz Vieira • 61 points
2 posts
-
4
votes5
answers6769
viewsA: Should I use GUID or int as the primary key?
I have used an alternative solution. I used a function that generates a random id with letters and numbers with 15 characters. I’ve run tests generating a billion sequences in a loop without…
-
2
votes3
answers7358
viewsA: How to avoid calculation error in SQL Server?
SELECT a.total cost products, a. datanote, a. numeronota, a. cfop ((a.totalnota / NULLIF(isnull(a.totalcustoproducts,0))) - 1.000) * 100 AS Totalmargem, FROM TB_C_VENDAS to WHERE a.numeronota > 0…