Running below query does not return any result, although running the same query on sql server return a one row, one clomun result as 1.
I want to use the result to check if everything goes well or not but nothing is returned when I test my query.
Code: Select all
-- Inline SQL script
DECLARE @RESULT INT
BEGIN TRY
BEGIN TRANSACTION
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = 0
WHERE [SST_Title] = 'UpdateInProgress' AND SST_UserId = 0
EXEC [P].[Common].[UML_Finish_WebServiceInstaller]
@UML_UpdateType = 1, --1 webservice
@UML_State = 1,-- 0: Inprogress, 1: Successfull, 2: Failed
@UML_ErrMsg = 'Success'
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = '02.00.00'
WHERE [SST_Title] = 'ApkTakeAwayVersion' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = '02.00.00'
WHERE [SST_Title] = 'WebserviceVersion' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = '02.00.00'
WHERE [SST_Title] = 'ApkPDAVersion' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = '02.00.00'
WHERE [SST_Title] = 'ApkAdminDashboardVersion' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = '1'
WHERE [SST_Title] = 'WebserviceUpdateIsForce' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = '0'
WHERE [SST_Title] = 'ApkPDAUpdateIsForce' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = '0'
WHERE [SST_Title] = 'ApkTakeAwayUpdateIsForce' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = '0'
WHERE [SST_Title] = 'ApkAdminDashboardUpdateIsForce' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = REPLACE('02.00.00','.','')
WHERE [SST_Title] = 'DownloadedWebserviceVersion' AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = REPLACE('02.00.00','.','')
WHERE ([SST_Title] = 'DownloadedApkPDAVersion' OR [SST_Title] = 'UpdateApkPDAVersion') AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = REPLACE('02.00.00','.','')
WHERE ([SST_Title] = 'DownloadedApkTakeAwayVersion' OR [SST_Title] = 'UpdateApkTakeAwayVersion') AND SST_UserId = 0
UPDATE [P].[Common].[SystemSetting]
SET [SST_Value] = REPLACE('02.00.00','.','')
WHERE ([SST_Title] = 'DownloadedApkAdminDashboardVersion' OR [SST_Title] ='UpdateApkAdminDashboardVersion' ) AND SST_UserId = 0
EXEC [Common].[UML_UpdateWebServiceVersion_WebServiceInstaller]
@UML_ToVersion = '02.00.00'
DECLARE @SOFTWARE_VERSION VARCHAR(8)
DECLARE @SOFTWARE_IS_FORCE BIT
IF 'P'='P'
BEGIN
SET @SOFTWARE_VERSION = '0594'
SET @SOFTWARE_IS_FORCE= '0'
END
ELSE
BEGIN
SET @SOFTWARE_VERSION = '0420'
SET @SOFTWARE_IS_FORCE = '0'
END
DECLARE @VRE_ID INT
SET @VRE_ID = (SELECT [VRE_ID]
FROM [P].[Common].[VersionsRelationHeader]
WHERE [VRE_WebserviceVersion]=REPLACE('02.00.00','.','') AND [VRE_SoftwareVersion]=@SOFTWARE_VERSION );
IF @VRE_ID IS NOT NULL
BEGIN
UPDATE [P].[Common].[VersionsRelationHeader]
SET [VRE_WebserviceIsForce] = '1'
WHERE [VRE_ID] = @VRE_ID
END
ELSE
BEGIN
DECLARE @VRE_WebserviceVersion NVARCHAR(20)
SET @VRE_WebserviceVersion = REPLACE('02.00.00','.','')
EXEC [P].[Common].[VRE_Insert_WebServiceInstaller]
@VRE_SoftwareVersion = @SOFTWARE_VERSION,
@VRE_SoftwareIsForce = @SOFTWARE_IS_FORCE,
@VRE_WebserviceVersion = @VRE_WebserviceVersion,
@VRE_WebserviceIsForce = '1',
@VRE_ID = @VRE_ID OUTPUT
END
DECLARE @VRD_ID INT
DECLARE @PDA_VERSION NVARCHAR(20)
DECLARE @DASHBOARD_VERSION NVARCHAR(20)
SET @PDA_VERSION = REPLACE('02.00.00','.','');
SET @DASHBOARD_VERSION = REPLACE('02.00.00','.','')
---- Version Relation Detail FOR PDA----
EXEC [P].[Common].[VRD_Insert_WebServiceInstaller]
@VRD_VRE_ID = @VRE_ID,
@VRD_Type = 0,
@VRD_Version = @PDA_VERSION,
@VRD_IsForce = '0',
@VRD_ID = @VRD_ID OUTPUT
---- Version Relation Detail FOR Admin Dashboard----
EXEC [P].[Common].[VRD_Insert_WebServiceInstaller]
@VRD_VRE_ID = @VRE_ID,
@VRD_Type = 0,
@VRD_Version = @DASHBOARD_VERSION,
@VRD_IsForce = '0',
@VRD_ID = @VRD_ID OUTPUT
COMMIT
SET @RESULT = 1
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK
SET @RESULT = 0
END CATCH
SELECT @RESULT AS RESULT