Design pattern

CREATE TABLE CustomerLarge
  (CustomerID               INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName             VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName  VARCHAR(40)
 , Address                  VARCHAR(20)
 , Address2                 VARCHAR(20)
 , City                     VARCHAR(20)
 , CountryCode              CHAR(3)
 , Postal                   VARCHAR(20)
 , creditlimit              INT
 , discount                 NUMERIC(4, 2)
 , lastorderdate            DATETIME
 , lastorderamount          NUMERIC(10, 2)
 , lastordercontact         VARCHAR(20)
 , created                  DATETIME
 , modified                 DATETIME
 , modifiedby               VARCHAR(20)
 , statusid                 INT
 , active                   BIT
 , customersize             INT
 , primarysalesid           INT);
GO

If I check the columns_updated() function return in a trigger, what is the data returned?

See possible answers

Design pattern

Blogs

Forums

Question of the Day

Cookies on SQLServerCentral