Sheet Columns

Order Field Name Values/Table Reference
0 Result Set Type 7
1 Sheet Id
  • Sheet_Columns.Sheet_Id
  • Sheets.Sheet_Id
2 User Id User.User_Id
3 Transaction Type
  • 1 = Add
  • 2 = Update
  • 3 = Delete
4 Timestamp Sheet_Columns.Result_On
5 Update Type
  • 0 = Pre-Update
  • 1 = Post-Update

Example


DECLARE	@SheetId	int

CREATE TABLE @SheetColumns (
ResultSetType	int DEFAULT 7,
SheetId	      int NULL,
UserId	       int NULL,
TransType	    int DEFAULT 1,
TimeStamp	    varchar(50) NULL,
PostUpdate	   int DEFAULT 0)

SELECT @SheetId = Sheet_Id 
FROM Sheets
WHERE Sheet_Desc = 'MySheet'

INSERT INTO @SheetColumns (	SheetId,
                                  TimeStamp)
VALUES (@SheetId,
convert(varchar(50), getdate(), 120))

-- Output results
SELECT	ResultSetType, 
            SheetId, 
            UserId, 
            TransType, 
            TimeStamp, 
            PostUpdate
FROM @SheetColumns