All,
I am using c#. I want to replace any special character with space character.
For eg,
str = "hello world*& c shar#p"
should be like this,
"hello world c shar p"
thanks,
rsrinivasan
Last Activity: Feb 5 '10, 04:47 AM
Joined: Mar 26 '07
Location: India
-
How to Change Font size
Hi all,
I am using SQL Server 2000. I have sent some eail through this procedure "xp_sendMai l". The problem is I have to format that email. The default font size is "2". I want to change it to "4". How can i do it?
Thanks, -
rsrinivasan replied to DTS: Copy new + modified records from table1 to table2 from two different serversin SQL ServerUse tableDiff utility of SQL SERVER 2005 that will sync only updated and inserted table. -
Thanks for it. It is working fine....Leave a comment:
-
Try to use this utility "tablediff.exe" , which campares two tables and gives some report.Leave a comment:
-
Tablediff Utility SQL server 2000
Hi all,
I am using SQL Server 2000. And i have found one great tool tablediff.exe utility to campare two tables. It is working in SQL SERVER 2005, but not in 2000. How to install this utility in SQL Server 2000.
Thanks, -
So what to do for this to store this result in some temp table. I do not have any idea to implement this. please suggest some way to do this....Leave a comment:
-
How to store the result set in temp table
Hi all,
When i run below statement, i get some result set. But i want to store the results sets in some temp table. How can i store it?
Thanks,Code:DBCC SHOWCONTIG ('table_name') WITH TABLERESULTS -
Thanks for this link. It really useful. In this I do not know how to get the ratio of disk writes to read. Please give some idea to get it.
Thanks,...Leave a comment:
-
Creating Reindex
Hi all,
When should we execute dbcc reindex for a table?
Thanks, -
Now I solved the problems. Thanks....Leave a comment:
-
I set Results in Text and executed the select query. But it also takes 18 minutes....Leave a comment:
-
Open record sets
Hi all,
I am using SQL server 2000.When i right-click on table-name and click open option in Query analyzer, it returns one million record within 10 seconds. But when i select recorde through query "Select * from tablename", it takes 10 minutes. What is difference between this?
Thanks, -
I shrinked that database. But it still shows 170GB in .mdf file.
Thanks,...Leave a comment:
-
Create Trigger
Hi all,
I have two tables source and target with same structure.
Now i want a trigger, that will update the same record in target table if any record is updated in source table. Is it possible?
Thanks, -
Ya. I can alter my staging table structue. But i can't be able to alter t_table structure....Leave a comment:
-
Try this, and reply me
Code:DECLARE @numberList varchar(255) Select @numberList = IsNull(number + ',' + @numberList, NULLIF( number, @numberList)) from <tablename> where <condition> Select @numberList as numberList
Leave a comment:
-
It is not possible to add a field in t_table. Because it is third party table. We can only access through select statement and insert into our staging table. So i need some other better way to sync it....Leave a comment:
-
Database size shows huge
Hi all,
I am using SQL Server 2000. My actual database size is only 19GB. But .mdf file shows 170GB. How can i reduce it?
Thanks, -
Thanks for your reply..
The transational table does not have any date and time field. The t_table has millions of record and some records(10 to 20) are updated daily. And some records are inserted into t_table daily.
Currently we delete all records in staging table and DTS all records from t_table.
And it takes around 2 hrs. So i have to implement incremental model to update the staging table.
...Leave a comment:
No activity results to display
Leave a comment: