Synapse Stored Procedure

Question

Synapse Stored Procedure

Sasidhara Rao Bade 5

Hi I am getting below Error

Stored procedure1
{
    "errorCode": "2402",
    "message": "Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 156. Error Message: Incorrect syntax near the keyword 'SELECT'.",
    "failureType": "UserError",
    "target": "Stored procedure1",
    "details": []
}

Note :- While i am running Stored procedure it is success

USE gold_db
GO

Sasidhara Rao Bade 5


GO

CREATE OR ALTER PROC CreateSQLServerlessView_gold @ViewName nvarchar(100)
AS
BEGIN

DECLARE @statement VARCHAR(MAX)
    SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+'AS
    SELECT * FROM OPENROWSET(BULK ''https://sasidharstorageaccountdemo.dfs.core.windows.net/silver/SalesLT/'+@ViewName+'/'',FORMAT = ''DELTA'') AS [result]'

EXEC (@statement)

END
GO

Anonymous

2023-10-25T04:26:19.96+00:00

Hi @Sasidhara Rao Bade Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Sasidhara Rao Bade 5 Reputation points

2023-10-22T16:15:02.2533333+00:00

GO CREATE OR ALTER PROC CreateSQLServerlessView_gold @ViewName nvarchar(100) AS BEGIN DECLARE @statement VARCHAR(MAX) SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+'AS SELECT * FROM OPENROWSET(BULK ''https://sasidharstorageaccountdemo.dfs.core.windows.net/silver/SalesLT/'+@ViewName+'/'',FORMAT = ''DELTA'') AS [result]' EXEC (@statement) END GO
Anonymous

2023-10-25T04:26:19.96+00:00

Hi @Sasidhara Rao Bade Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Erland Sommarskog 134.7K MVP Volunteer Moderator

Change

   SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+'AS

to

   SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+' AS

That is, you need a space before AS.

Anonymous

2023-10-26T09:05:41.2766667+00:00

Hi @Sasidhara Rao Bade

if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Synapse Stored Procedure

1 answer

Your answer