Posts by Wilton De Queiroz Vieira • 61 points

• 4

  votes

  5

  answers

  6769

  views

  A: 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…

  c# asp.net-mvc .net entity-framework guid

  answered 5 years, 2 months ago Wilton De Queiroz Vieira 61

• 2

  votes

  3

  answers

  7358

  views

  A: 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…

  sql sql-server

  answered 8 years, 3 months ago Wilton De Queiroz Vieira 61