In this sign I get error Incorrect syntax near please solveI dont want to change querydeclare s as nvarchar500SET s39PihNo not like 3939201819393939SELECT dboFUNCGETFINCYEARMAXISNULLPihNo0FROM PurchaseInvoiceHeader NOLOCK s

SQL Server Error: Incorrect syntax near +

gokuldas

SOLVED CLOSED ACTIVE ANSWERED
User: gokuldas
Posted: on May 10, 2023 01:59 AM
Forum: SQL Server
Replies: 1
Views: 598

In this + sign I get error Incorrect syntax near '+'.

please solve.

I dont want to change query.

declare @s as nvarchar(500);
SET @s='Pih_No not like ''201819%'''
SELECT [dbo].FUNC_GET_FINC_YEAR(MAX(ISNULL(Pih_No,0)))
FROM PurchaseInvoiceHeader (NOLOCK) + @s

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
User: dharmendr
Replied: on May 10, 2023 02:05 AM
Report

Hi gokuldas,

Use EXEC / EXECUTE command for executing dynamic SQL.

SQL

DECLARE @s AS NVARCHAR(500);
SET @s = 'Pih_No NOT LIKE ''201819%'''

DECLARE @Query NVARCHAR(MAX)
SET @Query = 'SELECT [dbo].FUNC_GET_FINC_YEAR(MAX(ISNULL(Pih_No,0)))
	      FROM PurchaseInvoiceHeader (NOLOCK)
              WHERE ' + @s
EXEC (@Query)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

SQL Server Error: Incorrect syntax near +

Company

Explore

Follow us

Contact Us