Posts Tagged ‘SQL Server’
If you directly use convert it gives you solution in terms of +e. But if we convert it to bigint first then it provide the correct conversion to string.
CONVERT(nvarchar, CAST(floattoconvert as bigint))
You can use str function but you need to be careful as it appends 0 or space while converting the same. So it would be bit tricky to use str function.
To resolve this error:
1. Open the registry key HKEY_LOCAL_MACHINE\System\CurrentControlSet
2. Rename the value DependOnService to anything
3. Restart the server
I was just making a view and found out that Order By statement in view is not working while fetching data in SQL Server 2008 browser. I have tested same in SQL Server 2005 browser and result is same.
Microsoft has released the hotfixes for the same and you can find it on below locations: