My requirement is to replace the special characters with space throughout the databse. How can I do this? I am new to this sql server. So any one could you please help me in this aspect.
Thanks in advance
View Complete Post
I would like to have an regular expression that does not allow any spaces(before,within,after the word) and alphanumeric characters.
Thanks in advance.
On one of my publishing page layout i have added Content Field (field of content type) that is
<SharePointWebControls:TextField FieldName="MyName" runat="server"></SharePointWebControls:TextField>
Then i edit the page which is using this page layout and add one text "Sandip" in that MyName field. Now problem is, this filed show the text on the page but at the end of it, it add space. i.e- "Sandip "
I m not getting why it is showing this.
My sql server 2005 instance has 83 databases. I would like to know how much space is being used by all the databases and top 5 list. Please let me know how to get this information.
I have this data:
LEADID LeadDeliveryLogId LDPId DeliveryStatus DeliveryDate
252761357 9256770 6536 IN_DELIVERY 8/1/2010 2:45:28.157
252761357 9256771 6536 DELIVERED 8/1/2010 2:45:28.240
252761357 9256783 6536 IN_DELIVERY 8/1/2010 2:46:15.273
252761357 9256784 6536 DELIVERED 8/1/2010 2:46:15.350
I need to group it into IN_DELIVERY-DELIVERED match, one match for each, so that I can tell the time difference between when it is IN_DELIVERY and when it is DELIVERED, but I want to make sure that the first IN_DELIVERY only gets matched to the first DELIVERED
based on the timeframe, and that it is not mixed up with the second DELIVERED. The result should be something like below (notice the first column):
GROUP LEADID LeadDeliveryLogId LDPId DeliveryStatus DeliveryDate
1 252761357 9256770 6536 IN_DELIVERY 8/1/2010 2:45:28.157
1 252761357 9256771 6536 DELIVERED &nbs
I have a drive 'F' with 40G free space. I try to restore a database whose data + log file size is 60G.
The restore fails. Is it because a full restore needs free disk space of 60G in this case?
I have some problem with RegEx.
I have text:
"something here [tagQuote=Name of Author]bla bla bla[/tagQuote] something here"
And now I want to replace all the whitespace character in quote attribute with "%#%#%#%".
So I want to have: [tagQuote=Name%#%#%#%of%#%#%#%Author]bla bla bla[/tagQuote]
So remove all of the whitespaces between "[tagQuote=" and "]...[/tagQuote]"
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 '
When I download a report rdl for edit from Report Manager, if there is a space character in the name then its replaced by and underscore.
For eg., if my Report name is "Test Report.rdl", when I download the rdl it comes up as "Test_Report.rdl". I have noticed this happening just recently and didn't occur earlier.
How do I get SSRS to stop replacing the space character with "_" ?
Appreciate any assistance on this.