Posts by Alexandru • 61 points

• 5

  votes

  1

  answer

  1048

  views

  Q: Can I invoke Function on a Trigger?

  My Function done on Sql-Server: CREATE FUNCTION dbo.getQuantidade(@idProd char) RETURNS float AS BEGIN DECLARE @QTD float SET @QTD = (SELECT (prod.Quantidade) FROM Produto prod where @id_prod =…

  sql-server oracle function trigger

  asked 8 years ago Alexandru 61

• 1

  votes

  1

  answer

  2356

  views

  Q: Incorrect syntax error near the keyword 'FROM'

  This code generates the following error: Msg 156, Level 15, State 1, Procedure totalGastoPedido, Line 7 Incorrect syntax near the keyword 'FROM'. CREATE FUNCTION dbo.totalGastoPedido(@id_mesa int)…

  sql-server

  asked 8 years ago Alexandru 61