C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




how to truncate in 1234.000000000 to 1234.00 in sql server?.


Posted Date: 23 Aug 2007      Total Responses: 3

Posted By: lakshmi       Member Level: Gold     Points: 2




i want to trim in sqlserver.after decimal only 2digits
1234.000000000
1234.00




Responses

Author: Balasubramaniyam    23 Aug 2007Member Level: GoldRating:     Points: 2
Response.Write(string.Format("{0:N2}", Convert.ToDouble("12.122222")));


Author: rohit ranjan    23 Aug 2007Member Level: SilverRating:     Points: 2
hi

set nocount on
declare @test decimal(10,2)

set @test= '1234.000000000'

select @test

Rohit Ranjan


Author: Danasegarane.A    23 Aug 2007Member Level: DiamondRating:     Points: 2
sorry Wrongly Post :)


Post Reply
You must Sign In to post a response.
Next : please send the VB.NET CODE websites?
Previous : how to generate sql script
Return to Discussion Forum
Post New Message
Category: .NET

Related Messages



dotNet Slackers   BizTalk Adaptors    Web Design

efax

Contact Us    Privacy Policy    Terms Of Use