How to cast data types
- MS Sql Server
- 622
- March-22-2018
- by Rizwan Saqib
How to cast data types
The Cast() function is used to convert a data type variable or data from one data type to another data type.
The Cast() function provides a data type to a dynamic parameter
For Example
There is four value and her data type is Varchar if we want add all values it is necessery to convert into Int
DECLARE @A varchar(10)
DECLARE @B varchar(10)
DECLARE @C varchar(10)
DECLARE @D varchar(10)
SET @A = 10
SET @B = 20
Set @C = 30
set @D = 40
Select Cast(@A as int) + CAST(@B AS int)+CAST(@C AS int)+CAST(@D AS int)TotalResult
Total Result = 100
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
you can view the more detail via link https://www.youtube.com/watch?v=HpZgwHU1GcIChing xang
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Danial Comb
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!