SELECT convert(numeric(38,0),cast('4.102e+011' AS float))
Sunday, April 24, 2016
Converting exponential number to numeric T-SQL
Following query can be used to convert an exponential number to numeric format.
SELECT convert(numeric(38,0),cast('4.102e+011' AS float))
SELECT convert(numeric(38,0),cast('4.102e+011' AS float))
Wednesday, February 24, 2016
Fixing "The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine."
If you have 64-bit Excel installed on 64-bit Windows 10 and are trying to import Excel data into 64-bit SQL Server, you may run into this error message
"The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine."
To resolve this issue, you will need to download "Microsoft Access Database Engine 2010 Redistributable"
After running the installer, the import operation should work.
Reference
http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/
http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx
"The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine."
To resolve this issue, you will need to download "Microsoft Access Database Engine 2010 Redistributable"
After running the installer, the import operation should work.
Reference
http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/
http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx
Subscribe to:
Posts (Atom)
What is success?
The journey of life takes us through varied experiences like landing an admission at a prestigious college, earning a degree, getting hired,...
-
Recently after a domain password change, I got the following error in trying to run the webrole. Can not log on locally to WebRole as us...
-
In trying to setup a site on a Windows 2008 server, I ran into the following error message Handler "PageHandlerFactory-Integrated"...
-
For some reason, Hive metastore.exe (which runs as a service) did not create the metastore db that is required for Hive to store table defi...