Hi
I have a table with a few hundred emailadresses. How can I delete all quotes (') from the addresses, so that'email@.email.com' is replaced asemail@.email.com.
Thank you
zipfeli
You can use the REPLACE Function. And you want to an UPDATE not a DELETE.
UPDATE table SET Column =REPLACE(column, '''', '')
|||
UPDATE TableName SET EMailAddrCol = REPLACE(EMailAddrCol, '''', '')
I hope this helps,
Best of Luck!
Hi
I want to insert 1000s of records into SQL Server 2005 Database with some manipulation. So that i put into the For Loop and inserting record.
Inside the loop i am opening the connection and closing after use. The sample code is below
for(int i=0;i<1000;i++)
{
sqlCmd.CommandText = "ProcName";
sqlCmd.Connection = sqlCon;
sqlCmd.Connection.Open():
sqlCmd.ExecuteNonQuery();
sqlCmd.Connection.Close();
}
What my Question is.. How is the Performance of this Code..?? Will is take time to get the Connection and Close the Connection in every itration?
Or Shall I Open the Connection in Begining of the outside loop and close the connection at end of the Loop? will it increase the Performace?
Please clarify me these question.. Thanks in advance.
Hi,
Opening a connection and closing it takes a lot of extra resources, so use following.
1sqlCmd.CommandText ="ProcName";2sqlCmd.Connection = sqlCon;3sqlCmd.Connection.Open():45for(int i=0;i<1000;i++)6{7 sqlCmd.ExecuteNonQuery();8}910sqlCmd.Connection.Close();11
Hi
I am developing an application where i want to store the different language (i.e. chines,Arabic,urdu etc) character in database (SQL Server). so when i store arabic characters in SQL server , it stores the (???).
datatype of field is nvarchar.
is anybody know about the problem and solution.
Regards
Mubahsar Ghazi
The problem is called character conversion and you are getting it because you are using only NVarchar without doing column level collation for Arabic in your database. There are three collations for Arabic in SQL Server 2005. If you are using SQL Server 2000 you can still do column level collation, the links below deals with SQL Server 2005. Hope this helps.
144
binary.256
Binary
SQL_Latin1_General_1256_BIN
145
diction.256
Dictionary order, case-sensitive
SQL_Latin1_General_Cp1256_CS_AS_KI_WI
146
nocase.256
Dictionary order, case-insensitive
SQL_Latin1_General_Cp1256_CI_AS_KI_WI
http://msdn2.microsoft.com/en-us/library/ms144250(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms180175(SQL.90).aspx
|||
thanks for ur response
but i m still getting problems.....
i m pasting the whole code below.while executing it show the exceptionCast from string "?" to type 'Byte' is not valid.
.....................
Dim cAsString = HelpArea.Text ' HelpArea is text box where urdu/arabic characters can be writenconvertC = UniToVar(c) ' function written below
Cmd =
New SqlCommand("INSERT INTO tblCategoryDetail(FieldLang,FieldHelp)Values(' " & dpLanguage.SelectedItem.Text & " ', " & convertC(c) & ")", con)lblMsg.Text = "Values have stored in database"
con.Open()
Cmd.ExecuteNonQuery()
CatchexAs ExceptionlblMsg.Text = ex.Message
EndTrycon.Close()
Public
Function UniToVar(ByVal sTextAsString)AsObjectTry
Dim b()AsByte
b = Encoding.Unicode.GetBytes(sText)
Return b
Catch exAs Exception
lblMsg.Text = ex.Message
EndTry
EndFunction
|||i have posted the whole function in previous message......and need the solution in very short time...... hoping early resopnse by ur side
regards
Mubashar Ghazi
|||I want to query the database using SQL statements that contain Arabic letters... for example, this query won't return any results that start with the letter '?' even though if I try any english letters it works perfectly:
SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '?' + '%')
I also tried switching:
SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '%' + '?')
but it won't work.. any ideas ?
Thanks :)
||| See if the posthttp://forums.asp.net/t/1167422.aspx can be helpful.