spGetSignOnControls
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ContentID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetSignOnControls]
@ContentID int
AS
SELECT [FieldID],[ParentFieldID],[FieldName],[CodeTableID],[AttribTypeID],[DataType],[UseShortDescription],'0' as ID, '0' as Display, '0' as Required
FROM applicationfields
WHERE (fieldid=101)
SELECT [FieldID],[ParentFieldID],[ID],[Required], [Display],[AttributeTypeID]
FROM SignOnControls WHERE ContentID = @ContentID