Covert
Dec 11, 2007Hi Guys,
Can you help me.. I want to convert this table
From
No. LineNo
01 3
02 0
To
No. LineNo
01 03
02 00
What query should I do?
Thanks,
DUDZ
ADVERTISEMENT
Covert Date
Apr 18, 2008how to convert date like :-9/2009 - to- 2009-01-09 00:00:00.000
thanks.
Covert Connection From Access To SQL
Jul 4, 2004Edited by haidar_bilal - Please place your code within < code > and < /code > tag. Thank you.
I've got to convert the following functions so it connects to the SQL server that uses this connection string: ("server=(local);database=BCA;Trusted_Connection=yes")
The code below works fine to an Access db. I know I've got to change all the Ole objects below to SQL objects to connect to SQL server. But try as I might, I'm still not getting them right. Can anyone help by showing me how to change the code? Please just take the code and substitute the SQL connection strings for the Access string. That way even I could understand it. Sigh.
Public Class Functions
Public Function GetCommandObject(ByVal strCommand As String, ByVal strPath As String, ByVal ExecuteIt As Boolean) As Data.OleDb.OleDbCommand
Dim objConnection As Data.OleDb.OleDbConnection = GetConnectionObject(strPath)
objConnection.Open()
Dim objCommand As New Data.OleDb.OleDbCommand(strCommand, objConnection)
If ExecuteIt = False Then
Return objCommand
Else
objCommand.ExecuteNonQuery()
End If
objConnection.Close()
End Function
Public Function GetConnectionObject(ByVal strPath As String) As Data.OleDb.OleDbConnection
Dim objConnection As New Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath)
Return objConnection
objConnection.Close()
End Function
Public Function GetReaderObject(ByVal strCommand As String, ByVal strPath As String) As Data.OleDb.OleDbDataReader
Dim objCommand As Data.OleDb.OleDbCommand = GetCommandObject(strCommand, strPath, False)
Dim objReader As Data.OleDb.OleDbDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
Return objReader
objReader.Close()
End Function
End Class
How To Covert Text To Datetime
Jan 31, 2006Hi
I have a field which is text. I want to convert it to datetime.
(the value of the field which has its data type as text is a date)
thanks inadvance
Transact SQL :: How To Covert Numeric Values To Abc
Jun 9, 2015I want to convert every numeric values into textstring like abc in sql or vb.net
My encoding is as under
0=alz
1=bmw
2=cn
3=dox
4=ep
5=fqy
6=gr
7=hsv
8=it
9=kuj
How can i covert these all numeric values equally above coding in sql server or vb.net...