Hello,
 

With which error, the installation of the script failed?

Hi, I am using SQL script in MSSQL. Please find my script below for creating Proc. 'UsrMemberData' is the object which i created in my app.

IF OBJECT_ID('UsrMemberData', 'P') IS NOT NULL BEGIN
   DROP Procedure UsrMemberData;
END
GO

CREATE Procedure UsrMemberData 
Begin
    SELECT * FROM UsrMemberData
End

It shows below error

Is SQL Script is working ony for any specific DBMS type? Can you please let me know how to work out this .

Thanks!

Hello,

The issue is likely due to the case sensitivity of SQL Server keywords and the positioning of the GO statement. Here’s the corrected script with proper syntax:

IF OBJECT_ID('UsrMemberData', 'P') IS NOT NULL 
BEGIN
   DROP PROCEDURE UsrMemberData;
END
GO

CREATE PROCEDURE UsrMemberData 
AS
BEGIN
   SELECT * FROM UsrMemberData; -- Assuming UsrMemberData is a table
END
GO
 

Hi,

Have tried with above code but still got the issue

Please find the script below,

IF OBJECT_ID('UsrMemberDataRetrieve', 'P') IS NOT NULL 
BEGIN
  DROP PROCEDURE UsrMemberDataRetrieve;
END
GO

CREATE PROCEDURE UsrMemberDataRetrieve 
AS
BEGIN
  SELECT * FROM UsrMemberDetailsData; 
END
GO

Can you please let me know sql script is compatible with any specific DBMS type. Thanks!