MSSQL Data Type 49 codes

1 Arithmetic overflow error converting numeric to data type varchar

2 Average of decimal values

3 Bit type column

4 CAST (original_expression AS desired_datatype)

5 CAST can still do date conversion

6 Cast date to different format

7 Cast date type to char

8 Cast decimal to varchar and append another string

9 Cast int to decimal

10 Cast number to varchar and use the regular expressions

11 Cast real number to decimal

12 Cast value to float

13 CAST(111172 as smalldatetime) AS 111172

14 CAST(123 4 AS Decimal)

15 CAST(2 78128 AS integer)

16 CAST(2 78128 AS money)

17 CAST(expression AS data type( length ))

18 CAST(ID AS VarChar(5))

19 Combine CONVERT() and DATEADD() to format

20 Conversion with CONVERT function for computated value with numbers in list

21 Convert date calculation result to int

22 CONVERT function syntax

23 Convert varchar to number

24 CONVERT() does the same thing as the CAST() function

25 CONVERT() Function Styles

26 CONVERT(varchar,Date,101)

27 Count null bit1 values

28 Decimal(15,4)

29 Declare variable in varchar type

30 Define and use money data type

31 Format decimal

32 Format money (currency)

33 Function returning decimal

34 Int type column

35 Int type parameter

36 Mixing Datatypes

37 Nchar data type

38 READTEXT in a loop to read chunks of text

39 RETURNS INT from a function

40 Select CAST(2002-09-30 11

41 Select CAST(CAST(2002-09-30 AS datetime) - CAST(2001-12-01 AS datetime) AS int)

42 SELECT CONVERT(VarChar(20), April 29, 1988)

43 SELECT CONVERT(VarChar(50), @Num, 2)

44 Specifying Fixed-Width Data Types for Table Columns

45 Specifying Variable-Width Data Types for Table Columns

46 Stored Procedure to Retrieve Employee Based Upon Order Date

47 The CAST() function accepts one argument, an expression

48 Use select to do the calculation

49 Varchar type parameter