SQL Server Service - Tables
Views support the Select statement and will ONLY return a List Service Object method.
Fig. 1. SQL Service Object Views methods displayed in the K2 Object Browser
Samples of Views scripts
 Copy Code |
|---|
|
CREATE VIEW [dbo].[ViewOfBothTables] AS SELECT dbo.WithCRUD.ID, dbo.WithoutCRUD.ID AS Expr1, dbo.WithCRUD.Description, dbo.WithCRUD.TextValue, dbo.WithCRUD.IntValue, dbo.WithoutCRUD.Description AS Expr2, dbo.WithoutCRUD.TextValue AS Expr3 FROM dbo.WithCRUD INNER JOIN dbo.WithoutCRUD ON dbo.WithCRUD.ID = dbo.WithoutCRUD.ID GO |
