Database

CREATE PROCEDURE MyFirstProc @cParam varchar(10)
AS
PRINT 'MyFirstProc ' + @cparam
EXEC MySecondProc @cparam
GO

CREATE PROCEDURE MySecondProc @cTest varchar(20)
AS
PRINT 'This is in MySecondProc ' + @cTest
GO

MyFirstProc testing<br />
This is in MySecondProc testing

CREATE TRIGGER UPDATE_REST1
ON [DBO].[FINTRADE]
FOR UPDATE
AS

IF UPDATE(FTRIDPAYMENT)
  UPDATE FINTRADE
    SET Z_YPOLOIPO= (SELECT ISNULL(I.TOTLAMOUNT,0) - ISNULL(PLH.TOTLAMOUNT,0) AS Z_YPOLOIPO
                     FROM INSERTED I, FINTRADE PLH
                     WHERE I.FTRIDPAYMENT=PLH.ID)
    FROM FINTRADE F, INSERTED I
    WHERE F.ID=I.ID

IF UPDATE(TOTLAMOUNT)
  UPDATE FINTRADE
  SET Z_YPOLOIPO= (SELECT ISNULL(PAR.TOTLAMOUNT,0) - ISNULL(I.TOTLAMOUNT,0) AS Z_YPOLOIPO
                   FROM INSERTED I, FINTRADE PAR
                   WHERE PAR.FTRIDPAYMENT=I.ID)
  FROM FINTRADE F, INSERTED I
  WHERE F.FTRIDPAYMENT=I.ID

andreas_635 wrote:

the application which runs triggers is treated like two triggers

<br />
SELECT Log.id, Log.LibraryID, Log.Action, Log.Date<br />
FROM Log<br />
WHERE (((Log.LibraryID)=[libid]) AND (DatePart("mm",Log.Date)+"-"+DatePart("dd",Log.Date)+"-"+DatePart("yyyy",Log.Date))=(	<br />
DatePart("mm",[checkdate])+"-"+DatePart("dd",[checkdate])+"-"+DatePart("yyyy",[checkdate])));<br />

steve_rm wrote:

Is there any method that I could use to detect if the database is current or not.

IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
              WHERE TABLE_NAME = 'MyTableName'
              AND COLUMN_NAME = 'ColumnName')
BEGIN
    -- Add the column we checked for
    ALTER TABLE ....
END