Tuesday, July 8, 2008
Let's Talk about .. SQL Server 2005-Cast variable type
This is a way to cast the type of variable from String to Decimal
[SQL]
Declare @CurrentYear as varchar(4)
set @CurrentYear = Cast(@NextYear as decimal(18,3))-1
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment