SELECT '≤ foo' for xml path(')
For the statement above in SQL Server 2008 I'm curious why the output it "= foo" instead of "≤ foo". Perhaps my XML Path statement needs to be different?
View Complete Post
I am going to design a application having front end with VB.Net and Back end with SQL SERVER in. And I want the complete interface of that
application in marathi language.
when I enter the marathi character in data base and execute it, it shows "????????" like this.
What I do to enter and store the marathi character in Database?
Can you please help me on this?
When I try to pass my parameter it doesn't work. See below is my code :
declare @SQL Varchar(4000)
declare @CRM_FilteredAppointment nvarchar(2000)
declare @CRM_FilteredSystemUser nvarchar(2000)
declare @StartDate datetime
declare @EndDate datetime
set @CRM_FilteredSystemUser = 'Select * from FilteredSystemUser'
set @StartDate = '20080101'
set @EndDate = '20100101'
set @CRM_FilteredAppointment = 'SELECT activityid, participationtypemask
WHERE FilteredAppointment.eu_calltype = 2
AND FilteredAppointment.statecode = 1
AND FilteredAppointment.scheduledend >= DateAdd( month, -1, GetD
I am using Sql Server 2005,My table structure is below.
Create Table ComentTable(id int,coments varchar(4000))
insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')
insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')
how to write storeprocedure update coments column replace %27 to '
i have grideview and i want to bind silverlight media control as follow