Posts by Jeferson Jácomo • 11 points

• 1

  votes

  2

  answers

  127

  views

  A: Prevent Insert or Update If date is in a Registered range

  Try something like create Trigger lock on TABLE for Insert as declare @int code, @data date, @int type select @codigo = codigo, @data = date, @type = type from inserted IF (@data between…

  c# sql sql-server trigger

  answered 5 years, 4 months ago Jeferson Jácomo 11

• 0

  votes

  1

  answer

  53

  views

  A: Doubt how to mount a query in Mysql

  These filter that you used in the case, put it in the clause Where at the bottom, and in the case you filter only the years. Following example: SELECT SUM(CASE WHEN(YEAR(DATA)) = 2017 THEN…

  mysql sql mysqli

  answered 5 years, 5 months ago Jeferson Jácomo 11

• 0

  votes

  1

  answer

  381

  views

  A: Bring last date of SQL Product

  The error is in the subquery you made, it is only bringing up a table date Venda_Item_Produto, note that if you run only this Select: SELECT DISTINCT TOP 1 DATA FROM Venda LEFT JOIN…

  sql database sql-server

  answered 5 years, 5 months ago Jeferson Jácomo 11