Manish Pansiniya's Blog

.NET, C#, Javascript, ASP.NET and lots more…:)

Posts Tagged ‘SQL Server

float to string sql cast or convert

leave a comment »

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.

Advertisements

Written by Manish

August 10, 2010 at 7:29 pm

Service Dependency deleted in Sql Server when enabling Full Text Search

leave a comment »

To resolve this error:

1. Open the registry key HKEY_LOCAL_MACHINE\System\CurrentControlSet
\Services\msftesql
2. Rename the value DependOnService to anything
3. Restart the server

Written by Manish

June 24, 2010 at 1:16 pm

ORDER BY in a View : Not allowed before but now HotFixed

leave a comment »

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:

http://support.microsoft.com/kb/926292/

Written by Manish

January 2, 2010 at 5:10 pm

Posted in SQL Server

Tagged with , ,