The data is in Unicode Character and our user will use this in VB.NET application. He is going to search a particular village, he wish to filter the data...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Villages](

[ID] [float] NOT NULL,

[TEHSIL] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CIRCLE] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[VILLAGE] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[THE] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CIR] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[VIL]...

I am using following code to update the "the" column of villages table. It is working but not updating the rows when i check the table. In the...

Thanks for your reply and provided link.

Actually i am having a table of 3 columns which is containing around 48000 rows having Unicode data. With the above code i...

then plz. tell me how can i execute this query ? if {} are not parenthesis; then what are parenthesis...

Thanks & Regards

I gave EXEC {@SQL} but still showing error : [Microsoft][ODBC SQL Server Driver]Syntax error or access violation.  But if i print the @sql string it shows executable query i.e....