SCRS_GetServicePack2 Stored Procedure
In SCRM 2006, SCRS_GetServicePack2 gets a list of operating system captions matching the pattern of two specific versions.
SCRS_GetServicePack2 @LocaleID ,@OperatingSystem ,[ @OSVersion1 = ] '<ALL>' ,[ @OSServicePack1 = ] '<ALL>' ,[ @OSVersion2 = ] '<ALL>' ,[ @OSServicePack2 = ] '<ALL>'
@LocaleID
Type: int
Locale identifier for the installed product.
@OperatingSystem
Type: nvarchar
Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSCaption.
@OSVersion1
Type: nvarchar
Value for flag determining whether output should exclude value provided by @OSServicePack1.
@OSServicePack1
Type: nvarchar
Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion.
@OSVersion2
Type: nvarchar
Value for flag determining whether output should exclude value provided by @OSServicePack2.
@OSServicePack2
Type: nvarchar
Value for conditioning query against SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion.
| Column name | Data Type | Description |
|---|---|---|
|
| ||
| OSServicePackVersion | String | Output value from SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion. |
| OSServicePackVersionLabel | String | Output value from SCRM 2006 SCRS_ManagedNode_Dimension_View.OSServicePackVersion. |