Question

MSSQL Database -Does each business will have separate database in Creatio?

Hi 

Have created stored proc through sql script but it was failed when trying to install. Considering SQL script execution is passed, will those SQL scripts be created in database, shall we assume that  each business will have separate database in Creatio?

Like 0

Like

4 comments

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!

 

 

 

 

 

 

Show all comments